im currently doing a vacation planner for 2012 for 20 staffs. I need the following result:
12 months in one sheet
auto color for specific leaves
generates a report for specific employee

Are these things possible in excel?