Share via

Conditional Formatting based on Dates

Anonymous
2022-10-10T13:43:02+00:00

Hi all,

I have a project where I am pushing out and pulling in already scheduled shipments due to changes in production schedule and inventory levels. However, if the new recommended delivery date is within 2 weeks of the current date, I don't act on it. Can someone help me with a formula that would highlight dates in the recommended delivery date column if it is within 2 weeks of the current delivery date.

I included a sample below. 'Promised Arrival Date' is the current scheduled delivery date, 'Sugg Dock Date' is the new date it is asking to be delivered,

Promised Arrival Date Sugg Dock Date
10/31/2022 10/19/2022
11/14/2022 10/19/2022
12/5/2022 10/19/2022
12/13/2022 10/21/2022
1/10/2023 10/21/2022
1/19/2023 10/21/2022
11/3/2022 11/2/2022
11/3/2022 11/2/2022
12/23/2022 11/2/2022
11/10/2022 11/7/2022
12/1/2022 11/7/2022
12/8/2022 11/8/2022
4/3/2023 11/14/2022
1/9/2023 11/16/2022
11/23/2022 11/22/2022
11/17/2023 11/24/2022
1/10/2023 11/29/2022
1/12/2023 11/29/2022
1/23/2023 12/7/2022

Thanks,

Lucas

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

HansV 462.6K Reputation points
2022-10-10T13:53:24+00:00

Let's say the Promised Arrival Date is in A2:A20 and the Sugg Dock Date in B2:B20.

Select B2:B20. B2 should be the active cell in the selection.

On the Home tab of the ribbon, select Conditional Formatting > New Rule...

Select 'Format only cells that contain'.

Leave the first drop down set to 'Cell Value'.

Select 'greater than' from the second drop down.

Enter the formula =A2-14 in the box next to it.

Click Format...

Activate the Fill tab.

Select a color.

Click OK, then click OK again.

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-10-10T15:32:28+00:00

    This is why you're the MVP, thank you so much Hans

    Was this answer helpful?

    0 comments