Creating formula in Excel
 

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!

Creating formula in Excel
 

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!

Creating formula in Excel
 

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

Creating formula in Excel
 

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

"CLR" wrote:

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

Creating formula in Excel
 

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

Vaya con Dios,
Chuck, CABGx3

"Josh" wrote:

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

"CLR" wrote:

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