ExcelBanter - Changing cell fill color as result of 'if' statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Changing cell fill color as result of 'if' statement (https://www.excelbanter.com/excel-programming/275725-re-changing-cell-fill-color-result-if-statement.html)

Phobos

Changing cell fill color as result of 'if' statement

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

All times are GMT +1. The time now is 09:35 AM.