Hi,
How can I write: IF B2 = "Goalie" OR "Defender" OR "Def Mid" AND C2 is not blank in Conditional Formatting?
Thanks in advance for your time.
Hi,
How can I write: IF B2 = "Goalie" OR "Defender" OR "Def Mid" AND C2 is not blank in Conditional Formatting?
Thanks in advance for your time.
Try
=AND($C2<>"",OR($B2="Goalie",$B2="Defender",$B2="Def Mid"))
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
try:
AND(C2<>"",OR(B2="Goalie",B2="Def Mid")) or
AND(NOT(ISBLANK(C2)),OR(B2="Goalie",B2="Def Mid"))
alt1
OR(B2="Goalie",B2="Def Mid")*(C2<>"")
alt2
IF(C2<>"",OR(B2="Goalie",B2="Def Mid"),FALSE)
IF(C2<>"",OR(B2="Goalie",B2="Def Mid"))
many ways,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks