No, you need conditional formatting for that.

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)


"Hague2" wrote in message
...
When using an IF statement (or any formula) can you include Formatting?
For
example, Yes answers GREEN and No answers RED. I believe you can do this
later using the conditional formatting, but can you include a formula
within
the IF statement's formula?
Thanks