Hi,
I am trying to build a spreadsheet that records staff sickness. I have made a spreadsheet (example supplied) that captures days off and a column at the end that will conditionally format the colours to display the current level, eg.. green, amber, red in a cell dependant on points accrued. Hope this is making sense??
I can send an example of the spreadsheet if anyone can assist.

Thanks everyone!!