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.

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

"gibsol" wrote:

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.

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

gibsol wrote:

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.