Adding transparent and color to IIf function that already has 4 condit

[Correenie]

I asked this question improperly yesterday. I know color can be applied in "Conditional Formatting," but I need the field to be transparent if two of the yes/no fields are No.

Here is where I need to add the color:
=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 if true, and "NS" appear on top of a light-blue background if true. If neither are true, then the field needs to be transparent. (If impossible for a color background, then the text to appear these colors instead).

How is this done?

Thanks,

Correenie

 

[Crowley16]

that's beyond the capabilities of conditional formatting, you'd have to use code to achieve that...

--------------------
Procrastinate Now!

 

[MichaelRed]

hmmmmmmmmmmmmmmmmmmmmmmm ... why is this "beyond the capability ... "? I have set quite a few conditional "values" on the same field, although to go beyond the 4 conditions seen in the wiz, you dom need to resort to a code technique, just interested in what the limitation is?



MichaelRed