Hello ,
I have two groups of staff, Admin Staff and Teaching Staff.
I would Like to highlight the Staff Attendance that is not punctual
The time for Admin Staff should not later than 8.00am where as for the Teaching Staff should not be later than 7.15am.
How do I use conditional formatting so that I could highlighted the staff that is late as shown in the Example below. Thank you very much for your help.
Example
[TABLE="width: 392"]
StaffName
[/td]Group
[/td]Timein
[/td]Steve
[/td]Admin
[/td]8.05AM
[/td]Rolland
[/td]Teacher
[/td]7.00AM
[/td]Rosalind
[/td]Teacher
[/td]7.16AM
[/td]Jannet
[/td]Admin
[/td]8.20AM
[/td]Decan
[/td]Admin
[/td]8.00AM
[/td]Lulu
[/td]Teacher
[/td]7.18AM
[/td]Hanna
[/td]Teacher
[/td]6.55AM
[/td]Collin
[/td]Teacher
[/td]6.50AM
[/td]
[/TABLE]
[/SIZE][TABLE="width: 262"]
[TABLE="width: 392"]
[TABLE="width: 392"]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/TABLE]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/TABLE]
[/TABLE]