change cell color when result is above a certain value

[Guest]

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?

 

[Guest]

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

 

[Guest]

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

regards
FSt1

 

[Guest]

Thanks
"reklamo"
Simple and effective

 

[Guest]

Again Thanks
Fst1
Simple and effective