Excel Challenge - Employee attendance record

  BrendanKK 09:22 08 Apr 11

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 11

Cross-posted click here

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

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac