View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chris01623
 
Posts: n/a
Default Automatic cell colouring

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?