Excel: Conditional formatting or another option?

I am working on an attendance spreadsheet where I want to be able to color code (conditional format) number of occurrences within a specific time frame. Right now I am calculating the total points and if it goes above a certain number then conditional formatting the cell. Here is what I want it to do and I don't know if Conditional formatting can be useful or if there is another formula to use: 1. If someone had more than 2 occurrences within a rolling 30 days I want the cell to highlight red. 2. If someone had one occurrences withing a rolling 30 days I want the cell to highlight yellow. 3. If someone had any occurrences within the first 14 days (work days - 5 days a week not 7) then it should highlight red. Help! Rachel

This question generated 20 answers. To proceed to the answers, click here.

This thread is current as of March 03, 2014.

For more resources for Microsoft Excel