Conditional formatting for dates approaching deadlines

Hi all,

I am currently working on composing a spreadsheet for work that will provide me with alerts for approaching deadlines - 10 days after an input date, and 48 hours before the deadline (the 10 days). While I have attempted several different formulas, none of them are quite giving me what I want, which is:


>>To provide me with a color coded alert (yellow) when the 48 hour (before deadline is up) is met. This would need to be Mon-Fri only (workdays)

>>To provide me with a color coded alert (red) when the 10 day deadline (this would need to count the day of the date - so, for instance, if I issued a notice to a client on 1/1/2016, I would also include 1/1/2016 in my count of 10 days.. so the deadline would be 1/10/2016).

Can someone please assist me with this issue? All suggestions are definitely welcome.

Thanks much!

>>To provide me with a color coded alert (yellow) when the 48 hour (before deadline is up) is met. This would need to be Mon-Fri only (workdays)

So when the deadline is less than 48 hours later than the day (excluding weekends), you want it to be yellow. Use this as a rule, where A2 is the input date and B2 is the deadline:

=NETWORKDAYS(A2,B2)<=2

This won't be precise down to the number of hours due the need to exclude weekends, but should be good enough for your purposes.

>>To provide me with a color coded alert (red) when the 10 day deadline (this would need to count the day of the date - so, for instance, if I issued a notice to a client on 1/1/2016, I would also include 1/1/2016 in my count of 10 days.. so the deadline would be 1/10/2016).

This requirement is not clear--you didn't finish your sentence. Do you want the alert when you are within 10 days of the deadline? Also you didn't mention excluding weekends, and your example does not do so. So, the rule would be

=B2-A2+1<10

If this isn't what you need, then please attach a file showing data with examples of the results you want.