Conditional Formating

M

Marlon Tomera

If A1-B1 is less than 3, I want cell C1 to turn "Red" and tell me to
"Reorder". And if C1 is greater than 3, I want cell C1 to turn "Green" and
tell me "Do not Order". Does anyone know how to set this formula up? Thanks
 
I

Ian Grega

Marlon

Put this formula in cell C1

=IF(A1-B1<3,"Reorder",IF(A1-B1>3,"Do not Order",""))

and then with conditional formatting on cell C1 "use a formula to determine
which cells to format";

Formula: =A1-B1>3 set format -fill to green
Formula: =A1-B1<3 set format - fill to red
 
M

Marlon Tomera

Ian,
That formula worked out beautifully. Thank you so much, I'm glad I went
ahead and signed up for this discussion group. Now I know where to find my
answers at LOL. Thanks again Ian.
 
I

Ian Grega

Cheers Marlon

Marlon Tomera said:
Ian,
That formula worked out beautifully. Thank you so much, I'm glad I went
ahead and signed up for this discussion group. Now I know where to find my
answers at LOL. Thanks again Ian.
Click to expand...
 

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

Coditional Format 4
need formula returning a blank cell 4
Conditional Format Range of Cells 3
Conditional Formating - formula not working 11
help with formula 1
Conditional 1
Conditional formating problem. Please help. 7
Writing Formula For conditional Formatting Using Excel 2000 3

Top