Add 2 colors to an IIf function that already has 4 conditions

[Correenie]

Greetings All!

Here is what works:
=IIf([Toured]=True,"GT",IIf([Not Qualified]=True,"NQ",IIf([No Show]=True,"NS",IIf([No Tour]=True,"NT",Null))))

I need to make "NQ" appear on top of a light-orange background and "NS" appear on top of a light-blue background. (If impossible, the text to appear the same colors).

How is this done?

Thanks,

~Correenie

 

[traingamer]

Format -> Conditional Formatting

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[Correenie]

Yes, but there is no transparent option (which is why I wanted to put it in the IIf).