Creating formula in Excel

  • Thread starter Thread starter Josh
  • Start date Start date
J

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!
 
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.
 
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.
 
Chuck,
Thats exactly what I wanted. I got my less that and greater than. Thankyou
very much!!!
 
Back
Top