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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Method Studios' title sequence for BBC series Taboo is truly unsettling

Best Pages for iOS tips | How to use Pages for iPad & iPhone: 7 simple tips to get more out of…