You need conditional formatting.

Look up 'Highlight cells that meet specific conditions' in the Answer
wizard in help


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mark" wrote in message
...
I am trying to make an IF statement results have different colored cells
depending on their outcome. For instance, if A=B, I want the cell to say
"GO"
with green fill around it. If A does not =B, I want the cell to say "STOP"
with red fill aound it. How can I do this?