Quick conditional formatting question???

  • Thread starter Thread starter FISH
  • Start date Start date
F

FISH

I want the number in a cell to be green if it is equal to or greater then
..50 and red if it is below .50.

I can use conditional formatting to make it green if it is equal to or
greater then, but how do I also make it red if it is below .50?

Thanks and sorry for the newbie question.
 
First, you can use Custom formatting rather than Conditional formatting,
which is a bit more efficient:

Format/Cells/Number/Custom: [Red][<0.5]General;[Green]General

Otherwise, just format your cells as Red, and use the CF to turn >=0.5
green.
 
Just add a condition and use either cell value less than .50 or
formula is =A2<0.50

where A2 is the cell in question


--


Regards,


Peo Sjoblom
 
Back
Top