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