It is called "Conditional Formatting" and the method depends on your
version of Excel. But you can look it up in Excel Help for assistance.

Josh wrote:

Hello everyone. I am trying to create a formula in Excel and need a little
help. I have created a workbook with my inventory in it. when the inventory
goes to a certail level I would like a cell to go from green to red. Red it
will say yes order and green will say no dont order. I know I need to use a
statement that shows <=0 but I cant figure it out. Please help!!

Merry Christmas as well!