Conditional Formatting [solved]

TerryM · Last edited by TerryM on Wed Nov 28, 2007 3:19 pm; edited 1 time in total

Is there a way of conditionally formatting a group of cells based on a condition in ONE of them?
I want three cells in a line to change to green when one of them is zero?

TerryM

squenson · Posted: Sun Mar 11, 2007 2:46 pm Post subject:

TerryM,

Select all the cells for which you want the same conditional formatting. Click on menu Format -> Conditional formatting..., then select "Formula is" in the first condition, then type (without the quotes): "$A$1=0" (replace $A$1 by the first cell of your selection). Finally, select the style.

Hope this help,
Stephane Quenson.
_________________
Help us to help you: Add [Solved] to the title of the thread if you agree with the answer
>>> Do you know the new OOo support forum http://user.services.openoffice.org/en/forum/index.php? <<<

TerryM · Posted: Sun Mar 11, 2007 6:45 pm Post subject:

Thanks, Stephane.

Simple when you know. I posted this without being too hopeful of a solution.

I was mis-interpreting the meaning of 'Formula is'

Aren't these formulas hard to get just right: in my case I had to allow for a slightly non-zero rounding error.

Terry