Ask Your Question

Why do my color bar conditions not show in calc?

asked 2018-01-11 00:32:58 +0200

jimberry gravatar image

Conditions for column C: !Conditions(

Resulting spreadsheet : !Spreadsheet(

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-01-11 02:01:36 +0200

librebel gravatar image

updated 2018-01-11 02:11:59 +0200

Hello @jimberry,

In your first image it can be seen that the cellrange is set at $K$1713 , i guess that should be rather something like C1:C100 or C1:E100.

( i have experienced it too sometimes that the cellrange is somehow altered, especially after i have re-edited the conditions )

In the menu "Format : Conditional Formatting : Manage..." you can check if your cellranges are correct.

HTH, lib

edit flag offensive delete link more


Ooops! I should have proofread that before uploading, shouldn't I? I have now replaced it to show the correct conditions !Conditions( but even after saving, closing and re-opening the spreadsheet, the color bars are still not showing. The screenshot only shows the values for condition 2, but the spreadsheet has many examples that should match that condition.

jimberry gravatar imagejimberry ( 2018-01-11 04:25:49 +0200 )edit

Did you check the "Manage" menu if there are any other conditions that do not belong there ?

librebel gravatar imagelibrebel ( 2018-01-11 04:35:15 +0200 )edit

Yes, and I deleted all other sets (there are 4 ranges in this set of conditions and no overlaps).

jimberry gravatar imagejimberry ( 2018-01-11 04:44:15 +0200 )edit

Please upload a sample document that contains the conditional formatting.

librebel gravatar imagelibrebel ( 2018-01-11 04:49:22 +0200 )edit

Here is a sample spreadsheet !Spreadsheet(

jimberry gravatar imagejimberry ( 2018-01-11 05:23:39 +0200 )edit

It seems that the problem is in the chosen Cell styles ( red , green, etc ) ... If you choose one of the built-in styles such as "Accent", "Good", "Bad" etc., then the formatting is shown.

librebel gravatar imagelibrebel ( 2018-01-11 05:35:14 +0200 )edit

Thankyou very much for clarifying that!!!! I am now able to accomplish what I set out to do. I thought the color styles were "built-in" - maybe I have been able to add those color styles in a previous attempt to use this feature, and then forgotten about it. But I wonder why it is possible to add styles but not to use them?

jimberry gravatar imagejimberry ( 2018-01-11 06:13:48 +0200 )edit

You're welcome sir , glad that it works now:) I was wondering too if that was perhaps caused by missing style definitions, in that case Calc should not present them in the list...

librebel gravatar imagelibrebel ( 2018-01-11 06:32:00 +0200 )edit

I have found that the F11 function key gets me into an edit mode where I can modify the red/green etc colour styles. These styles had obviously not been completed in a long-forgotten previous attempt ;-) - now I can have as many colors as I want without using non-specific style names.

jimberry gravatar imagejimberry ( 2018-01-11 06:57:56 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-01-11 00:32:58 +0200

Seen: 27 times

Last updated: Jan 11 '18