Experience Level: Intermediate
I am looking to produce a calendar in excel which shows the financial year of 2011 and 2012 in a yearly view. Which then automatically highlights days that work projects are occuring on.
I have found the following template ( http://office.microsoft.com/en-gb/templates/dynamic-calendar-TC102050402.aspx ) which highlights holidays. Which can then obviously be edited so that work projects can be highlighted.
However I would like the ability to block out several days. For example by inputting the start and end date, a whole week could be highlighted.
Currently each single day would need to be inputted.
Also , could you could you quote for adding conditional formatting so that different projects on the calendar could be colour coded differently. For example \'Team 1\' would highlight the calendar in yellow and \'Team 2\'s projects could be red.
Daniel M.0% (0)
8 Apr 2011
Create an account now and send a proposal now to get this project.Sign up
Clarification Board Ask a Question
There are no clarification messages.