gravanoc
Active Member
- Joined
- Oct 20, 2015
- Messages
- 348
- Office Version
- 365
- Platform
- Windows
- Mobile
I have a chart of exercises that shouldn't be repeated within a 3 day timeframe. What I would like is for the conditional formatting to highlight all instances where they are repeated within any 3 day range. My current rule doesn't seem to work as well as I'd like. It highlights the first instance, but not the other. My rule is =COUNTIF($L4:$Z6,L4)>1 for reference.
Here's what it looks like:
Here's what it looks like: