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?

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?

Thanks
"reklamo"
Simple and effective

hi,
read up on the conditional format function.
click cell D6. then on the tool bar, click formatconditional format
if cell value is.....greater then......1.4..........pick your color.

regards
FSt1

"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?

Again Thanks
Fst1
Simple and effective