Conditional Formatting

[gibsol]

I have 3 data columns, one returns the solution and need to be formatted to
be red or green depending upon the result, however, if col 1 is blank I would
like the solution column to be unformatted or formatted white, eg col 1 =
10, col 2 = 12, col 3 = 2. Col 3 would be green, if col 1 was blank I would
like col 3 to be white.
Hope I have explained my problem.

 

[Mike H]

You don't get around to telling us when you would like col C to Red but to
cover your other 2 conditions select as many cell in column C as you want then

Format|Conditional format
Cell value is
Equal to
enter 2 and pick green
Click OK

Mke

 

[Bob I]

use the "Formula is" option instead of "Cell value is" in conditional
formatting.