Hi,

I've got an excel worksheet and I want to add some conditions to a range of cells (Column). The conditions are as follows -

1) Three or more occasions off sick in a 12 week period,

2) six occasions off sick in a rolling year

c) 3 to 5 occasions of sickness absence totaling twelve or more days in a rolling year

Firstly do you know if this is possible in excel, if so would it involve using VB and nested if statements be the be way

Regards