How to mark attendance on employee attendance tracker using latest excel?

I am trying to figure out the template. how is the attendance marked on it? moreover, is there a way i can use a color to identify present and absent employee on a particular date?