Conditional formatting google sheets, match date between two dates- mark that row that is matching

2
votes

I am looking for a way to match any date in a column of dates with a bunch of start/end periods at columns next to it. If any match, mark my cell. I have managed to do this for one row, but I would like it to look at a whole column (or set range ex X6-X10) and compare with a bunch of date-periods in two columns.

Any one with any ideas of how I can do that?

This is what I have come up with so far: enter image description here

And I am using this formula: =AND($X$6>=$R$6,$X$6<=$T$6)

But, as I said, this only works for one row today. I would like to look through all rows in the columns.

1
google-sheetsgoogle-sheets-formulaconditional-formatting

1 Answers

2
votes

This formula should work:

=COUNTIFS(X$6:X,">="&R6,X$6:X,"<="&T6)

enter image description here