Hello,

Using Excel97 on WINNT.

I have a spreadsheet I am using to plan rosters for about 20 people each month. There are a known number of reasons for some of these people not to be available on specific days i.e. on leave, rostered off, other work commitment, etc.

Currently, I work through these manually and use a colour to fill the cell related to the day the employee is unavailable e.g. on leave means the cell is coloured red.

Could anyone please tell me if it is possible to make the selection from the combo box "Leave" but have the cell turn to red rather than display the word "Leave"? If this is possible, please advise how to do it.