Hi all,

I am using excel to manage our employees (25) holidays for 2005. The idea i am using at present is names on the left and dates on the top. I am then using a countif formula to count the amount of days that employee has through the year eg:-

1 = Holiday
2 = 1/2 Days Holiday
3 = Sick Day
4 = Day without pay

Example:- On January 3rd David was Sick so I would type the number 3 in the cell

Is there anyway i can get the cell background colour to change when 1,2,3, & 4 are entered in to the cell? If possible the font colour to change to the same as the background colour!!!?? Obviously if nothing is in the cell it will remain white

Thanks Craig