i wanted to know if there was a formula i could apply to cells to change
their color automatically if a cell value drops below a certian number?
can someone please help


--
sflcowboy78
------------------------------------------------------------------------
sflcowboy78's Profile: http://www.excelforum.com/member.php...o&userid=27327
View this thread: http://www.excelforum.com/showthread...hreadid=468256

Yes. There is a feature to do exactly what you want. Pull-down Format
Conditional Formatting... and enter the conditions.

Have a good day.
--
Gary''s Student


"sflcowboy78" wrote:


i wanted to know if there was a formula i could apply to cells to change
their color automatically if a cell value drops below a certian number?
can someone please help


--
sflcowboy78
------------------------------------------------------------------------
sflcowboy78's Profile: http://www.excelforum.com/member.php...o&userid=27327
View this thread: http://www.excelforum.com/showthread...hreadid=468256

Hi "sflcowboy78" ,
Some help with Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"Gary''s Student" wrote ...
Yes. There is a feature to do exactly what you want. Pull-down Format
Conditional Formatting... and enter the conditions.

"sflcowboy78" wrote:
i wanted to know if there was a formula i could apply to cells to change
their color automatically if a cell value drops below a certian number?
can someone please help