Excel Challenge - Employee attendance record

  BrendanKK 09:22 08 Apr 2011

I want to design an employee attendance record with conditional formatting that will high-lght the following

1. Ten consecutive days absent
2. Three or more separate periods of absence in a three month period
3. Five spells of separate periods of absence in a twelve month period.

What I would like is amber to high-light in Amber when an individual is approaching one of the above targets and Red once the target is reached.

I would appreciate any suggestions on how I would go about designing spreadsheet.

  VoG II 10:47 08 Apr 2011

Cross-posted click here

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

See mcbess's iconic style animated for Mercedes-Benz

iPhone X news: Release date, price, new features & specs

Black Friday 2017 : date, sites participants & bonnes affaires