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

T

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!
 
M

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
 
T

TWWARD

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top