cell background colour

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

Conditional Formating will do this - set your rules for your first cell and then copy down or manually edit the range in the rules manager

link to Microsofts Office page explaining it better than I could

@ bugmonsta. Did you notice the date on Post#1?