Conditional Formatting Around Weekends

**robatbrightstar** · 12-19-2013, 05:37 PM

I'm trying to set up a list of employees and dates in two separate columns. The date column represents the date we need to call an employee. I'd like the employee's name cell to fill "red" if the date is equal to the current date, or if it is Friday and the date is on the Saturday, Sunday or Monday upcoming, to turn red. We need to reach out to our employees before their shifts, and the office is not open on the weekends. Is there a simple way to do this?

Should I use the networksdays function on this?

Thanks for your help!

**Melvinrobb** · 12-19-2013, 05:49 PM

You should be able to do this by using the TODAY and WEEKDAY function.
Uploading a sample workbook, and manually highlighting certain scenarios to help illustrate what you would want conditionally formatted would be a good idea.

**daffodil11** · 12-19-2013, 05:59 PM

I had my names in A, dates in B and set the formatting to:

=IF(OR($B2=TODAY(),AND(WEEKDAY(TODAY(),2)=5,OR(WEEKDAY($B2+1,2)=6,WEEKDAY($B2+1,2)=7,WEEKDAY($B2+1,2)=1))),TRUE,FALSE)

**robatbrightstar** · 12-20-2013, 02:43 PM

Thanks daffodil11. The problem with this is it highlights all the weekend days. I only need the current week to turn red. The idea being that my staff would only call out to those employees who are red that week. Any thoughts?