Hey Everybody,
I am trying to format an employee attendance sheet so that all columns that fall on a weekend are highlighted. I have attached a sample worksheet with name removed. As you can see, the first columns that I'd like highlighted would be for Jan 4th-5th. Normally, I wouldn't mind manually highlighting these as we progress through the year, but it'd be nice to have the conditional formatting automated in the event that I add new employees, etc. If anybody wouldn't mind helping me out with this one, I'd appreciate it!
Thank you!
Bookmarks