change cell color when result is above a certain value
Scenario
A simple survey form that asks for input data width & height measurements
and after a simple (B6*C6) formula, gives the area size in the adjacent cell
(D6).
Problem
I'd like the (D6) cell to change colour if the value is above a certain
amount (1.4 for example)
Any ideas?
|