View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JohannM JohannM is offline
external usenet poster
 
Posts: 13
Default 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