skinnea
Board Regular
- Joined
- Mar 15, 2003
- Messages
- 135
- Office Version
- 365
- Platform
- Windows
I have a list of Wednesday dates in column A. I want to conditionally format the list such that the next upcoming Wednesday is highlighted up until we are past it (ie the day after).
I’ve tried a bunch of IF AND NOT TODAY() formulas and had some success at identifying bits of the overall outcome (is today before or after each date), but can’t get a single formula to do the whole thing.
Can anyone put me out of my misery…?
Many thanks in advance!
I’ve tried a bunch of IF AND NOT TODAY() formulas and had some success at identifying bits of the overall outcome (is today before or after each date), but can’t get a single formula to do the whole thing.
Can anyone put me out of my misery…?
Many thanks in advance!