Jessica has attended:
Excel Intermediate course
Alerts
We have a 12 month rolling sickness spreadsheet in which an employee can only take a maximum of 5 days. I would like to use conditioning formatting to highlight when an employee has overtaken on sick days, however I'm unsure on what the formula is. Also, when adding in new months is there a way to have that formula automatically be added to those cells?
RE: Alerts
Hi Lisa
I would advise using a separate column to count your sick days per person and then using conditional formatting to highlight when that count exceeds 5.
It does depend though on whether you're using plain text to mark it off as "sick" or if you're adding dates to the column. If you're using text, then I would use COUNTIF.
If your data is formatted using the Table function, that could automatically extend the conditional formatting and corresponding formula.
Regards,
Wendy
