Forum Discussion
Solved
Conditional Formatting using =TODAY formula
Hello everyone, I’m trying to create some formatting rules in Excel where the formatting rules include the =TODAY formula. I’ve managed to reach the desired outcome for a single row (the form...
Does the attached example show what you want to do?
=$A1<=TODAY()-10
This is the first rule for conditional formatting. I've only added the $ sign to your rule.
=$B$1:$B$9
This is the range the conditional format applies to in the example.
Does the attached example show what you want to do?
=$A1<=TODAY()-10
This is the first rule for conditional formatting. I've only added the $ sign to your rule.
=$B$1:$B$9
This is the range the conditional format applies to in the example.
- Hi Oliver,
This seems to do exactly what I need - thank you so much for your help! Appreciate you may not have time to but, if you do, can you explain why my formula didn’t work in this same way?
