Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic cell colouring
You can use conditional formating in all the table, with a formula like this:
=(COUNTIF($A$2:$A$100,$A2)4) Supposing that you have in column A any unique identifier for the employee, this will be TRUE, so it will show the highlight, when that Id is found more than four times in the column. You may have change the column and the row count to fit your scenario. Hope this helps, Miguel. "Chris01623" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
resetting last cell | Excel Discussion (Misc queries) | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
AUTOMATIC way to copy the value of a cell in one spreadsheet | Excel Worksheet Functions | |||
cell color index comparison | New Users to Excel | |||
Possible Lookup Table | Excel Worksheet Functions |