'if then' color changes.......................

[TWWARD]

I am trying to change the color of the text(numeric value) in a cell if it
meets certain criteria.

Example: A1= average of B1:H1

The values in B1:H1 will turn Blue if 5% < than A1
The values in B1:H1 will turn Red if 5% < than A1

A1 B1 C1 D1 E1 F1 G1 H1
441 425 374 478 422 446 456 488
(RED) (BLUE)
(BLUE)

Any help would be greatly appreciated!

 

[Max]

Try it like this ..

Select B1:H1 (B1 active),
then apply the CF using Formula Is:

Condition 1
=B1>$A1*1.05
Format Blue fill

Condition 2
=B1<$A1*0.95
Format Red Fill
Ok out

 

[Max]

oops, typos ..

Format Blue fill ....
Format Red Fill

"Fill" should read as: "Font"

 

[TWWARD]

I will try that, but I didn't mention I am using 2003, not 2007, will that
make a difference?

 

[Max]

I will try that, but I didn't mention I am using 2003, not 2007, will that
make a difference?

Steps given are for xl2003, my ver.