SyntaxFix
Write A Post
Hire A Developer
Questions
Select ColumnB and as two CF formula rules apply:
Green: =AND(B1048576="X",B1="Y")
=AND(B1048576="X",B1="Y")
Red: =AND(B1048576="X",B1="W")
=AND(B1048576="X",B1="W")