conditional formatting?

Giganews Newsgroups
Subject: conditional formatting?
Posted by:  Valery2105
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)
(start)      (end)
1                Excel                    formulas & pivot tables
31/06/06  02/07/06

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!