Macro to format different range of cells each time
 

Hi

I'm looking for some help - I am not an expert at Visual Basic.

I have an excel holiday chart which i want to use macros to assign when
someone has taken a days holiday, sick etc. For each employee the
number of days holiday is totalled by a CountIf function. For each
time of absence a different colour is assigned. For example, If holiday
is taken the cell is coloured red & a number 1 is assigned to each day
the employee has taken off.

Currently the macro i have tried to assign is either assigning the
colour to the full range but not the number 1's.

I'm using Excel 2003.

Any help is appreciated.