Annual Leave Calender

Hello,

I am new to this site and i found many useful infos while going to through it.

i need to create a annual leave planner for my company in which each employee will be given a particular color and once his days of leave reuested, the calender in the excel file should be highlight from th starting date to end date with that particular color.

any ideas..

THnaks in advance