Excel97 Conditional formatting question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Zilbandy - 17 Oct 2006 08:02 GMT

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.

Signature

Zilbandy - Tucson, Arizona USA <zil@zilbandyREMOVETHIS.com>
Dead Suburban's Home Page: http://zilbandy.com/suburb/
PGP Public Key: http://zilbandy.com/pgpkey.htm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Reply to this Message

Bob Phillips - 17 Oct 2006 09:20 GMT

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

Signature

HTH

Bob Phillips

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

> 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.

Reply to this Message

roy.patrice@uqam.ca - 17 Oct 2006 12:56 GMT

Hi,

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

Hope this helps

Pat

Reply to this Message