"Langoose" wrote in message
...
I'm want to use an "IF" formula to compare the values in two cells and
return
the following...

IF cell A is equal to cell B I want the formula cell to be yellow with a
"Y"
in it
IF cell A is greater than cell B I want the formula cell to be green with
a
"G" in it
IF cell A is smaller than cell B by more than 1000 I want the formula cell
to be red with an "R" in it
IF cell A is smaller than cell B by less than 1000 I want the formula cell
to be yellow with a "Y" in it

=IF(A1B1,"G",IF(A1<B1-1000,"R","Y"))
And then use conditional format, if cell value ="R" make the background red,
etc.
--
David Biddulph