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.