In localc, I’ve successfully conditionally formatted background color and font size.
But my changes to the number style do not seem to take effect. The column is formatted to ‘(1234.12)’. When the value is zero, I’d like the it displayed as a single zero, not zero.zerozero. Thus I’d like the number style to be ‘-1234’. But setting it to ‘-1234’ does not seem to have an effect.
Thanks. I got 0.00_);(0.00);0 to work using Format → Cells… → Numbers tab
.
Better yet, I used 0.00_);(0.00);"" so that the cell appears empty, which is what I really wanted.
.
FWIW, I could not get it work via Format → Conditional Formatting → New Style
Better yet, a single semicolon does the same thing as two quotation marks.
But 0.00_);(0.00);; will also hide cells that look like numbers but are actually text—sometimes this trick can help you spot errors in your data or formulas.
Just try again and again. Make sure the condition is met correctly for this cell. And check the style applied to the cell if the condition is NOT met. I can only offer advice, as a verbal description of your problem is clearly insufficient—the attached sample file would provide much more information.
Thanks for the tip
The number format code is itself conditional formatting, so once you enlightened me of the 4 section syntax, I didn’t see a reason to persevere on conditional formatting of conditional formatting.
