Excel97 Conditional formatting question

[Zilbandy]

Using conditional formatting, I need to know if this is possible: If
the value of cell A1 is is between the value of B1 and 2500 then I
want to set the font color and background color of cell A1 to some
other color than the default.

 

[Bob Phillips]

Just use the Between condition, with bounds of =B1 and 2500.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[roy.patrice]

Hi,

You'll find more information on conditional formating here:
http://youlearnexcel.com/presentation.htm#exlpresformec

Hope this helps

Pat