Timesheet Attendance Checker

So are you saying that you need to cross reference between the two sheets to ensure that if someone is shown on the Attendance sheet as something other than Worked then there are no hours recorded on Time Sheet data for the equivalent day?

eg

Lisa shows as R&R for 05/09/22 so you need to check no hours exist for her on that day?

Perhaps this will help.
Apply the following conditional formatting rules to the attendance sheet:
1. For those instances when the date is not listed on the time sheet on a particular employee who has "worked" on attendance sheet (amber fill):

Formula:

Please Login or Register  to view this content.

2. For those instances when the employee has a different notation on the time sheet for a particular date (red fill):

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.