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