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