Try recording each of the two results that you would like i.e get the
macro recorder going and change a cell fill colour to green and
another to red.
Then from what you've recorded you should be able to take out the bits
of code you want and put them into the If..else statement.

Jason

"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