You may get a better idea from the response from T.Valko in this discussion
just a few posts below your original.
http://www.microsoft.com/office/comm...776&sloc=en-us

"Fonzy" wrote:

Hi,

I'm trying to set a formula so that if a cell value is less than a number
e.g 50 it turns the cell green and then if the value is 51 or more it turns
the cell green. Is this possible,

Thanks

Chris