Adding Color to a Cell

[=!CmOrE!=]

Hello all,

I would like to be able to change the color of a cell when a specific
value is attained. E.g. If the statement 1+1=2 is TRUE then make the
cell where the 2 is, Green. If the statement is FALSE then change the
color to red.

Thank you in advance

 

[VBA Noob]

Try conditional Formatting

See attached link which explains it

http://www.meadinkent.co.uk/conditional-formatting.htm

VBA Noo

 

[=!CmOrE!=]

THANK YOU!!