Changing background color based on two different words

[hammermill21]

Hello,

I have a table that when there is a "Y" under "entrapment" I want the cells to turn yellow and if there is a "Y' under Vandalism I want the cell to turn red.  I know if I do this:

if(Entrapment='', white(),    yellow())

It will work but how do I add the Vandalism part to this expression?

Thank you!

[sunny_talwar · Accepted solution]

May be this

If(Entrapment = 'Y', Yellow(),

     If(Vandalism = 'Y', Red(), White()))

[Anil_Babu_Samineni]

Perhaps this?

If(Entrapment='', White(), If(Vandalism='Y', Red(), Yellow()))

[hammermill21]

Thank you Sunny,

I see what I did wrong when i tried that.

Thank you

[sunny_talwar]

What was it, if you don't mind sharing that

[hammermill21]

I had it set  like this:

if(Entrapment='', white(),    yellow())

     if(Vandalism='', red(), white()))

I needed to remove the first "White()", an oversight on my part.

[sunny_talwar]

Make sense, thanks for sharing