Forum Discussion
Attendance Calendar
Hi
I have downloaded the attendance calendar from Excel. However, I have part-time employees who would like to grey out the days they do not work, such as Wed and Thur, if their names are chosen in C2. Can anyone help me with the formula? I need to do this in conditional formatting.
I have added some dummy working days to the List of Employees sheet, and created a new rule for the Calendar View sheet.
8 Replies
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Hi
Please let me know if this link workshttps://iehubltd-my.sharepoint.com/:x:/g/personal/jill_iehub_org/EfJAcpEcuSdDqlA06kX4OAMBIMrVpoLRLW_PXOfdC7eOXw?e=uc0my6 this is the original downloaded sheet without any of my team's details in.
As you will see in conditional formatting, Sat/Sun are greyed out, I would like to do the same with other days but only if a team member who does not work Wed and Thurs is chosen from the drop-down where it says Select Employee. I have a selection of full-time and part-time team members.
Thanks
Jill
Thanks, but where does it specify the days of the week a particular employee does not work?
