Use a conditional formatting. Select cell D6, select Format - Conditional
Formatting,
select "Cell value is" - "greatern than" - insert the desired value -
define the desired format.
Thats it
reklamo

"Jeremy" wrote:

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?