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...
If you want the row to highlight only when multiple people have the same day off and no one has coverage, you can try this formula in conditional formatting:
=AND(
COUNTIFS($B$4:$B$100, $B4, $D$4:$D$100, "") > 1,
$D4 = "",
$E4 = ""
)
Basically:
It checks how many people are off on the same day with no coverage.
If it's more than 1 and this specific row also has no coverage listed in either column, it highlights.
Should give you what you're going for with the 4/24 vs 4/25 situation. Let me know if it gives you any trouble — happy to tweak it.