I am trying to find out the correct formula for conditional formatting days of the week.
In cell B2 I have the date (ex: 7/1/2008)
In cell B1 I have the day of the week (B1=B2 but the format is DDD so it shows up Tue)
I would like to highlight B1:Z1 (end of data range) and turn any Thursday, Friday or Saturday into red font with grey background. Any suggestions? Thank you in advance!
In cell B2 I have the date (ex: 7/1/2008)
In cell B1 I have the day of the week (B1=B2 but the format is DDD so it shows up Tue)
I would like to highlight B1:Z1 (end of data range) and turn any Thursday, Friday or Saturday into red font with grey background. Any suggestions? Thank you in advance!