Quick conditional formatting question???

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

 

[JE McGimpsey]

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.

 

[Peo Sjoblom]

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