Adding formats to a formula

[goofy78270]

Is it possible to add a format to a formula such as

IF(A1=1,(red)true,IF(A1=2,(blue),""))

I have attempted to do this with no luck so far.

 

[Jonmo1]

Take a look at conditional formatting on the Format Toolbar...

 

[goofy78270]

Thanks for this, but I understand conditional formatting. I am looking to set the format based on eight different conditions; conditional formatting is limited to three.

Sorry I did not mention this in the original post.

 

[VoG]

This may help http://www.vbaexpress.com/kb/getarticle.php?kb_id=90