Creating formula in Excel

[Josh]

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!

 

[Bob I]

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.

 

[CLR]

The feature you need is called Conditional Formatting......among other
things, it will change the background color of a cell based on the value
therein. You can access it by doing Format > Conditional Formatting > and
then follow the menu. Post back here if you need more help.

Vaya con Dios,
Chuck, CABGx3

........and, Merry Christmas to you too.

 

[Josh]

Chuck,
Thats exactly what I wanted. I got my less that and greater than. Thankyou
very much!!!

 

[CLR]

You're very welcome Josh........thanks for the feedback.

Vaya con Dios,
Chuck, CABGx3