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?

change cell color when result is above a certain value
 

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?

change cell color when result is above a certain value
 

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?

change cell color when result is above a certain value
 

Thanks
"reklamo"
Simple and effective

change cell color when result is above a certain value
 

Again Thanks
Fst1
Simple and effective