u/ManyOreoZ

Conditional Formatting Based On Values "in a row"

Conditional Formatting Based On Values "in a row"

I'm looking to find a way to conditionally format the following sheet. I need a way to highlight an entire row in red if two values next to each other are false. For example, if an individual didn't attend on 05/24 and 06/07, they would be flagged/highlighted, but if they attended one in the middle, but didn't attend 05/24 and 06/21, I don't want them to be flagged. Is this possible?

Note: The Hiatus field here is irrelevant. I've figured that one out.

u/ManyOreoZ — 4 days ago