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?

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

"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

Again Thanks
Fst1
Simple and effective