Dear Excel Forum members,
I'm using Excel 2016 but can't get the conditional formatting to work the way I expect it to.
I am trying to create an Employee Leave Tracker. The plan is to create one month and then use that as a template for the other 11 months of the year. I will then link that data back to a summary sheet. I've made a basic calendar, but wanted to use conditional formatting to highlight the weekends (which for us is Friday and Saturday). I used the formula:
=WEEKDAY($B1, 1)>5
and asked for the arguments that are true, to turn Green. But pretty much everything in my query turned green!!! I'm sure this is user error but clueless as to where I am going wrong. I've attached my spreadsheet to show you.
Hoping someone can help me as I feel like I've searched the internet and come up with nothing!!!
Open to any and all feedback.
Bookmarks