Conditional Formatting Formula

[ammdumas]

Gr.

First off, this is formula that works =AND($E13<>"",$F13=0,$V13<>"Admin")

So if E is not blank and F is zero (or blank) and V is not "Admin", give me conditional formatting.

However, the moment I change it so that V can't be one of multiple items, conditional formatting stops working. Here are the combos I have tried...

=AND($E13<>"",$F13=0,OR($V13<>"Admin",$V13<>"Coordination",$V13<>"Support"))
=AND($E13<>"",$F13=0,$V13<>OR("Admin","Coordination","Support"))
=OR(AND($E13<>"",$F13=0,$V13<>"Admin"),AND($E13<>"",$F13=0,$V13<>"Coordination"),AND($E13<>"",$F13=0,$V13<>"Support"))


What am I doing wrong?

 

[njimack]

=AND($E13<>"",$F13=0,$V13<>"Admin",$V13<>"Coordination",$V13<>"Support")

 

[bryonwoods30]

don't do the combos... just keep going with your original formula

=AND($E13<>"",$F13=0,$V13<>"Admin",$V<>)

 

[ammdumas]

Gah! Was staring me right in the eyes. Thanks.