Hi!
I need to create a new routine so that it will highlight in the "Summary" sheet in
i) red for courses that the staff has not attended after the deadline has passed, and
ii) yellow for courses that the staff has attended but only after the deadline has passed.
This has to be based on the "Attendance List" sheet
Attached is the excel file.
Any help is much appreciated!!
I need to create a new routine so that it will highlight in the "Summary" sheet in
i) red for courses that the staff has not attended after the deadline has passed, and
ii) yellow for courses that the staff has attended but only after the deadline has passed.
This has to be based on the "Attendance List" sheet
Attached is the excel file.
Any help is much appreciated!!