|Date:||Mon, 26 Jun 2006|
Please help - I have the following on a spreadsheet:
col 36 col 37 col 38
col 39 col 40
(No.) (training title) (description)
1 Excel formulas & pivot tables
The No. column (col 36) and the training title column (col 37) are colour
filled (there are 29 training titles each filled with a different colour).
What I would like is to create an annual calendar that is always visible and
that when I enter the start date and end date it would automatically colour
the applicable date ranges in that colour.
Is this possible? Please help!