need to highlight cell if date indicated is less than or equal to 2 business day of date today

need help on conditional formatting on how to highlight cells that has a value of a date that is less than or equal to 2 business days from today.

example 1: Date Input: Friday, January 10, 2020 Date today: Wednesday, January 8, 2020 value is equal to 2 business day from today so it should be highlighted.

example 2: Date Input: Monday, January 13, 2020 Date today: Thursday, January 9, 2020 value is equal to 2 business day from today so it should be highlighted.

Please help.

thanks in advance


Solution 1:

Create a new conditional formatting rule based on a formula. For the formula you can use the NETWORKDAYS worksheet function. Apply whatever formatting you want. In my example I apply a yellow fill to the cell if the rule matches. You need to use the absolute value of what NETWORKDAYS returns, thus the use of ABS. Use NOW() in the formula to get the current date.

enter image description here

Then make sure the rule applies to your specific range:

enter image description here