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?
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?