I have a spreadsheet logging sickness, each person at work has their own
table, what i would like to do is when a person has been off for 4 occassions
(not days off, the amount of times they have called in sick), i would like
their whole table to highlight to alert me the have been off sick 4 times.
It looks something like
First day of absence Last day of Absence Reason
Number of days
01/05/06 05/05/06 Cold
5
And so on for each person. Can anyone help?
Bookmarks