Forum Discussion

JudahBannister's avatar
JudahBannister
Copper Contributor
Oct 30, 2024

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 this not possible? If not does anyone have a good work around for this?

Excel
Formulas and Functions
  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    Oct 30, 2024
    Hope that would be possible. Can you please share a sample workbook?
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Oct 30, 2024

    JudahBannister 

    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.

Resources