Color coded results in Excel's if function?

[Asdf0qwerty]

Hi everyone,

In this statement, =IF(A1="Sat","Yes","No"), is it possible that I "color code" the results, like if it is a match the Yes will appear in green, otherwise No in red. TIA

 

[alansidman]

Yes, this is possible. You will need to use Conditional Formatting. It is in the Format Menu depending upon which version of Excel you are using.

Alan

 

[Asdf0qwerty]

Got it Alan :D Thanks and GBY!