Forum Discussion
Conditional Formatting with Dates
Here are some links to do it yourself :).
The learning experience is extraordinarily larger than the ready-made solution.
Use conditional formatting to highlight information
Conditional formatting can help make patterns and trends in your data more apparent. To use it, you create rules that determine the format of cells based on their values
How to conditional formatting based on date in Excel?
As we known, the Conditional Formatting can auto change cell format based on the cell contents. This upper link, I will introduce how to conditional formatting cells based on date in Excel.
NikolinoDE Thank you !!! I have tried but I am not sure is it right or not, can you confirm
Amber =TODAY()+14<C2
Red =AND(TODAY()>C2,C2<>"")
Looking forward
- NikolinoDEJan 01, 2023Platinum Contributor
Here is an example file...
If it's over the date, then RED
If it is between 1 day and 14 days before the date then YELLOW
If it is 15 days before the date WHITE