work :IF statement

[c4hung]

Hi, I know how to work the if statement and get it to return a value in excel. But is there a way to use the if statement to not only return a value but for example make a cell a different color?? Thanks.

[ratcat]

G'day and welcome to the forum,

This is one way


http://www.contextures.com/xlCondFormat01.html


Cheers