Use "conditional formatting".

P


"Stuart" wrote in message
...
I have an if then else statement which will give one of
two results.
One of those results I would like to change the fill color
of the cell to red and the other result I want the cell to
be green.

How can I program this if statement so that it works?

Stuart