Creating formula in Excel

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!
 
B

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.
 
C

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.
 
J

Josh

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with formula 0
Program buttons to create a word document 0
Mail Merge Help 1
How to filter rows data based on background color of individual cells 3
Merging from an Excel file with graphics 1
Standard Deviation and Averages based on criteria 2
Conditional Formatting in Excel 2003 2
Cumulative formula for word table 0

Top