Forum Discussion
DavidKA
Jan 01, 2023Copper Contributor
Conditional Formatting with Dates
Could anyone help me with the formula so I can enter in conditional formatting. What I’d like to do is have the third column flag up when someone’s date is approaching with say 2 weeks notice (t...
NikolinoDE
Jan 01, 2023Platinum Contributor
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.