Adding Color to a Cell
 

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

Adding Color to a Cell
 

Try conditional Formatting

See attached link which explains it

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

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=563146

Adding Color to a Cell
 

THANK YOU!!
VBA Noob wrote:
Try conditional Formatting

See attached link which explains it

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

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=563146