I have an attendance tracker right now where it's dated 1/1/15 through 12/31/15. Each box, for each employee, has a drop-down that allows you to select one of 3 incidents - LA, LE or CI for Late, Left Early and Called In - if there was an incident.
The way the point system at work works is that if you're late or leave early you get 1 point, if you call in you get 2 and if you go a pay cycle without any incidents (la, le, ci) you get 2 points back.
Is there a way to define days (pay days) and state that if an employee doesn't have an incident during this time period after their last incident, 2 points are deducted from the overall total? I've got the points to add up correctly, I just can't figure out how to remove them after a certain time.
If there IS a way to do this, is there a way to make it so that if the points equal 10 at any time during the calendar year, the background color changes red or some color?