Changing a cell colour based on value

[martyloo]

I have a couple of IF functions in some cells when they trigger I would like the cell to change colour, is this possible???

Also is there anyway if not changing the colour i can keep a cell blank untill the IF function is triggered?

Thanks in advance

 

[VoG]

Perhaps you want Conditional Formatting http://www.contextures.com/xlCondFormat01.html

 

[martyloo]

Hi VoG,

Yeh I remember this on the older versions of excel, im using 2010 now and have no idea how to do it?

Thanks for your reply

 

[VoG]

Home tab > Conditional Formatting.