Changing one cell colour by inserting date in another cell
Following is an excample of my spread sheet:
A B C D E F G
H
1 Start Date : MONTH
2 : F : S : S : M : T : W : T
:
3 : 1 : 2 : 3 : 4 : 5 : 6
: 7 :
------------------------------------------------------------------------------
4 ? : ? : : : : :
: :
I would like cell B4 (1st day of Sept.) to change to a colour when I enter
the date (01/09/06) in cell A4.
Is this possible?
Many thanks
|