I have some sample data in which I am trying to highlight duplicate values relative by date. In this case I only want to the rule to account for dates in the past 3 weeks (current week + 2 weeks back).
I want to also highlight based on how many occurrences, I've done this with the two following rules
=COUNTIF($B$11:$B$36, $B11) >= 3
=COUNTIF($B$11:$B$36, $B11) = 2
How would I incorporate this to look only at the last 3 weeks instead of pre defined ranges? There is a highlight with "A date occurring" but I'm unsure if there is way to link these. Would this be possible by using some kind of helper table to gather the data of the 'highlighted dates' first?
I've attached a screenshot of what this would look like.