Forum Discussion
Conditional Formatting Formula
I am trying to create a formula for conditional formatting to check that if two individuals have the same day off and neither have coverage, then the rows for those two highlight red. If one does fin...
Try this formula. A4 or another cell in row 4 should be the active cell when you create the formula.
=AND(COUNTIFS($A$4:$A$1000, "<>"&$A4, $B$4:$B$1000, $B4, $C$4:$C$1000, $C4), COUNTIFS($B$4:$B$1000, $B4, $C$4:$C$1000, $C4, $D$4:$D$1000, "<>")=0)