Time Validation - VBA

Hi All!

I have been struggling with this for the past three days--I need a conditional formatting formula (or vba code) that will check the clock ins I have created/will create against each employee's listed availability. I also want to be able to copy this whole section over to the next columns over for new "sets of employees". Let me know if I can provide additional information! Thank you!

- update - I realize now, I need it to be a macro because I want to be able to copy and paste the cells. Ideally, I want to click a button, and it will highlight out of range cells in the whole sheet.