JohnTravolski
New Member
- Joined
- Nov 25, 2015
- Messages
- 45
- Office Version
- 2019
- Platform
- Windows
I have a column of dates that are spaced at least two days apart but sometimes more, but always an even number. For example, the column may look like:
What I want is conditional formatting to highlight the maximum of every date where the date integer value modulo 4 has a remainder of 1 and another one highlighting in a different color where the remainder is 3. In other words, if I were to apply it to the above column, I should get this:
I would prefer to do this without any kind of helper column, if possible. What would the conditional formatting formula look like for this column?
What I want is conditional formatting to highlight the maximum of every date where the date integer value modulo 4 has a remainder of 1 and another one highlighting in a different color where the remainder is 3. In other words, if I were to apply it to the above column, I should get this:
I would prefer to do this without any kind of helper column, if possible. What would the conditional formatting formula look like for this column?