Color

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you display a certain color in a cell for a formula for example in the
formula

= IF C4-C5>0 than display "Order", but display cell in red
but in same cell
= IF C4-C5<0 than display "No Order", but display in Green

I know it is confusing but how do I do this?
 
Use conditional formatting on format menu for change color as you want.
use this formula in condition formatting for C4-C5 >0
=C4>C5

and use this formula in conditional formatting for C4-C5 < 0 in condition2
=C4<C5
 

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

Hiding formula if cel reference is blank 2
change cell color depending on two cell values 1
Formatting issue 2
Getting a cell to state 1 thing if another cell states something 1
#REF! 1
Excel - disable automatic function 4
Conditional formatting multiple cells from one cell to another 3
Using the Icon Set for Conditional Formatting 1

Back
Top