Forum Discussion
JudahBannister
Oct 30, 2024Copper Contributor
EXCEL - Conditional Formatting - Date Occurring
Hi All, I'm trying to set up conditional formatting for dates occurring within the previous fortnight but I can either only choose the last week or the last month. Am I not seeing the option or is ...
HansVogelaar
Oct 30, 2024MVP
Let's say you want to apply this to D2:D100.
Select this range. D2 should be the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=AND(D2>=TODAY()-14, D2<=TODAY())
Click Format...
Activate the Fill tab.
Select a fill color.
Click OK, then click OK again.