Highlight todays date in an excel calendar

[RayJay]

Hi all,

I have a calendar in excel that looks like this:

<TABLE style="WIDTH: 360pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=475 border=0 x:str><COLGROUP><COL style="WIDTH: 94pt; mso-width-source: userset; mso-width-alt: 4571" width=125><COL style="WIDTH: 19pt; mso-width-source: userset; mso-width-alt: 914" span=14 width=25><TBODY><TR style="HEIGHT: 18.75pt; mso-height-source: userset" height=25><TD class=xl39 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e2e2e2; WIDTH: 94pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18.75pt; BACKGROUND-COLOR: #000099" align=right width=125 height=25 x:num="39814">January 2009</TD><TD class=xl24 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BACKGROUND: #ccffff; BORDER-LEFT: windowtext; COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" width=25 x:str=""></TD><TD class=xl25 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BACKGROUND: #ccffff; BORDER-LEFT: silver; COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" width=25 x:str=""></TD><TD class=xl25 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BACKGROUND: #ccffff; BORDER-LEFT: silver; COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" width=25 x:str=""></TD><TD class=xl25 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; WIDTH: 19pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" align=right width=25 x:num="39814">1</TD><TD class=xl41 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; WIDTH: 19pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc00" align=right width=25 x:num="39815">2</TD><TD class=xl45 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; WIDTH: 19pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" align=right width=25 x:num="39816">3</TD><TD class=xl46 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; WIDTH: 19pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" align=right width=25 x:num="39817">4</TD><TD class=xl26 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e2e2e2; WIDTH: 19pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" align=right width=25 x:num="39818">5</TD><TD class=xl25 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; WIDTH: 19pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" align=right width=25 x:num="39819">6</TD><TD class=xl25 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; WIDTH: 19pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" align=right width=25 x:num="39820">7</TD><TD class=xl25 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; WIDTH: 19pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" align=right width=25 x:num="39821">8</TD><TD class=xl25 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; WIDTH: 19pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" align=right width=25 x:num="39822">9</TD><TD class=xl45 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; WIDTH: 19pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" align=right width=25 x:num="39823">10</TD><TD class=xl46 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; WIDTH: 19pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" align=right width=25 x:num="39824">11</TD></TR><TR style="HEIGHT: 18.75pt; mso-height-source: userset" height=25><TD class=xl36 style="BORDER-RIGHT: #e2e2e2; BORDER-TOP: windowtext; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 18.75pt; BACKGROUND-COLOR: white" height=25></TD><TD class=xl27 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl28 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl28 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl28 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl42 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffcc00"></TD><TD class=xl47 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl48 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl29 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl28 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl28 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl28 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl28 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl47 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl48 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD></TR><TR style="HEIGHT: 18.75pt; mso-height-source: userset" height=25><TD class=xl37 style="BORDER-RIGHT: #e2e2e2; BORDER-TOP: silver; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 18.75pt; BACKGROUND-COLOR: white" height=25></TD><TD class=xl30 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl43 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffcc00"></TD><TD class=xl49 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl50 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl32 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl49 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl50 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD></TR><TR style="HEIGHT: 18.75pt; mso-height-source: userset" height=25><TD class=xl37 style="BORDER-RIGHT: #e2e2e2; BORDER-TOP: silver; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 18.75pt; BACKGROUND-COLOR: white" height=25></TD><TD class=xl30 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl43 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffcc00"></TD><TD class=xl49 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl50 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl32 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl49 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl50 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD></TR><TR style="HEIGHT: 18.75pt; mso-height-source: userset" height=25><TD class=xl38 style="BORDER-RIGHT: #e2e2e2; BORDER-TOP: silver; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: #e2e2e2; HEIGHT: 18.75pt; BACKGROUND-COLOR: white" height=25></TD><TD class=xl33 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl34 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl34 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl34 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl44 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: #ffcc00"></TD><TD class=xl51 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl52 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl35 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl34 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl34 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl34 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl34 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl51 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl52 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: #ffff99"></TD></TR><TR style="HEIGHT: 18.75pt; mso-height-source: userset" height=25><TD class=xl40 style="BORDER-RIGHT: #e2e2e2; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18.75pt; BACKGROUND-COLOR: #000099" align=right height=25 x:num="39845" x:fmla="=DATE(YEAR(A1+35),MONTH(A1+35),1)">February 2009</TD><TD class=xl24 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BACKGROUND: #ccffff; BORDER-LEFT: windowtext 0.5pt solid; COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" x:str=""></TD><TD class=xl25 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BACKGROUND: #ccffff; BORDER-LEFT: silver; COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" x:str=""></TD><TD class=xl25 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BACKGROUND: #ccffff; BORDER-LEFT: silver; COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" x:str=""></TD><TD class=xl25 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BACKGROUND: #ccffff; BORDER-LEFT: silver; COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" x:str=""></TD><TD class=xl25 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BACKGROUND: #ccffff; BORDER-LEFT: silver; COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" x:str=""></TD><TD class=xl45 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BACKGROUND: #ccffff; BORDER-LEFT: silver; COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" x:str=""></TD><TD class=xl46 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" align=right x:num="39845">1</TD><TD class=xl26 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" align=right x:num="39846">2</TD><TD class=xl25 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" align=right x:num="39847">3</TD><TD class=xl25 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" align=right x:num="39848">4</TD><TD class=xl25 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" align=right x:num="39849">5</TD><TD class=xl25 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" align=right x:num="39850">6</TD><TD class=xl45 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" align=right x:num="39851">7</TD><TD class=xl46 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" align=right x:num="39852">8</TD></TR><TR style="HEIGHT: 18.75pt; mso-height-source: userset" height=25><TD class=xl36 style="BORDER-RIGHT: #e2e2e2; BORDER-TOP: windowtext; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 18.75pt; BACKGROUND-COLOR: white" height=25></TD><TD class=xl27 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl28 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl28 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl28 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl28 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl47 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl48 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl29 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl28 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl28 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl28 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl28 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl47 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl48 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD></TR><TR style="HEIGHT: 18.75pt; mso-height-source: userset" height=25><TD class=xl37 style="BORDER-RIGHT: #e2e2e2; BORDER-TOP: silver; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 18.75pt; BACKGROUND-COLOR: white" height=25></TD><TD class=xl30 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl49 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl50 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl32 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl49 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl50 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD></TR><TR style="HEIGHT: 18.75pt; mso-height-source: userset" height=25><TD class=xl37 style="BORDER-RIGHT: #e2e2e2; BORDER-TOP: silver; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 18.75pt; BACKGROUND-COLOR: white" height=25></TD><TD class=xl30 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl49 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl50 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl32 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl49 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl50 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD></TR><TR style="HEIGHT: 18.75pt; mso-height-source: userset" height=25><TD class=xl38 style="BORDER-RIGHT: #e2e2e2; BORDER-TOP: silver; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: #e2e2e2; HEIGHT: 18.75pt; BACKGROUND-COLOR: white" height=25></TD><TD class=xl33 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl34 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl34 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl34 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl34 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl51 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl52 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl35 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl34 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl34 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl34 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl34 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl51 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl52 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: #ffff99"></TD></TR></TBODY></TABLE>

etc. for all days of the month, and all months of the year.

(The gold coloured cells are part of a formula I have somewhere else - no need to worry about them)

I was wondering - is there a way to get it so that whatever todays date is, the calendar will highlight the column a specific colour (e.g.) if the date was the 5th January, it would look like this:

<TABLE style="WIDTH: 360pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=475 border=0 x:str><COLGROUP><COL style="WIDTH: 94pt; mso-width-source: userset; mso-width-alt: 4571" width=125><COL style="WIDTH: 19pt; mso-width-source: userset; mso-width-alt: 914" span=14 width=25><TBODY><TR style="HEIGHT: 18.75pt; mso-height-source: userset" height=25><TD class=xl39 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e2e2e2; WIDTH: 94pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18.75pt; BACKGROUND-COLOR: #000099" align=right width=125 height=25 x:num="39814">January 2009</TD><TD class=xl24 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BACKGROUND: #ccffff; BORDER-LEFT: windowtext; COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" width=25 x:str=""></TD><TD class=xl25 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BACKGROUND: #ccffff; BORDER-LEFT: silver; COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" width=25 x:str=""></TD><TD class=xl25 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BACKGROUND: #ccffff; BORDER-LEFT: silver; COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" width=25 x:str=""></TD><TD class=xl25 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; WIDTH: 19pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" align=right width=25 x:num="39814">1</TD><TD class=xl41 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; WIDTH: 19pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc00" align=right width=25 x:num="39815">2</TD><TD class=xl45 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; WIDTH: 19pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" align=right width=25 x:num="39816">3</TD><TD class=xl46 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; WIDTH: 19pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" align=right width=25 x:num="39817">4</TD><TD class=xl53 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e2e2e2; WIDTH: 19pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #99cc00" align=right width=25 x:num="39818">5</TD><TD class=xl25 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; WIDTH: 19pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" align=right width=25 x:num="39819">6</TD><TD class=xl25 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; WIDTH: 19pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" align=right width=25 x:num="39820">7</TD><TD class=xl25 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; WIDTH: 19pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" align=right width=25 x:num="39821">8</TD><TD class=xl25 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; WIDTH: 19pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" align=right width=25 x:num="39822">9</TD><TD class=xl45 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; WIDTH: 19pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" align=right width=25 x:num="39823">10</TD><TD class=xl46 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; WIDTH: 19pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" align=right width=25 x:num="39824">11</TD></TR><TR style="HEIGHT: 18.75pt; mso-height-source: userset" height=25><TD class=xl36 style="BORDER-RIGHT: #e2e2e2; BORDER-TOP: windowtext; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 18.75pt; BACKGROUND-COLOR: white" height=25></TD><TD class=xl27 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl28 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl28 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl28 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl42 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffcc00"></TD><TD class=xl47 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl48 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl54 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #99cc00"></TD><TD class=xl28 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl28 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl28 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl28 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl47 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl48 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD></TR><TR style="HEIGHT: 18.75pt; mso-height-source: userset" height=25><TD class=xl37 style="BORDER-RIGHT: #e2e2e2; BORDER-TOP: silver; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 18.75pt; BACKGROUND-COLOR: white" height=25></TD><TD class=xl30 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl43 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffcc00"></TD><TD class=xl49 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl50 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl55 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #99cc00"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl49 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl50 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD></TR><TR style="HEIGHT: 18.75pt; mso-height-source: userset" height=25><TD class=xl37 style="BORDER-RIGHT: #e2e2e2; BORDER-TOP: silver; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 18.75pt; BACKGROUND-COLOR: white" height=25></TD><TD class=xl30 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl43 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffcc00"></TD><TD class=xl49 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl50 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl55 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #99cc00"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl49 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl50 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD></TR><TR style="HEIGHT: 18.75pt; mso-height-source: userset" height=25><TD class=xl38 style="BORDER-RIGHT: #e2e2e2; BORDER-TOP: silver; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: #e2e2e2; HEIGHT: 18.75pt; BACKGROUND-COLOR: white" height=25></TD><TD class=xl33 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl34 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl34 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl34 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl44 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: #ffcc00"></TD><TD class=xl51 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl52 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl56 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: #99cc00"></TD><TD class=xl34 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl34 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl34 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl34 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl51 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl52 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: #ffff99"></TD></TR><TR style="HEIGHT: 18.75pt; mso-height-source: userset" height=25><TD class=xl40 style="BORDER-RIGHT: #e2e2e2; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18.75pt; BACKGROUND-COLOR: #000099" align=right height=25 x:num="39845" x:fmla="=DATE(YEAR(A1+35),MONTH(A1+35),1)">February 2009</TD><TD class=xl24 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BACKGROUND: #ccffff; BORDER-LEFT: windowtext 0.5pt solid; COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" x:str=""></TD><TD class=xl25 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BACKGROUND: #ccffff; BORDER-LEFT: silver; COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" x:str=""></TD><TD class=xl25 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BACKGROUND: #ccffff; BORDER-LEFT: silver; COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" x:str=""></TD><TD class=xl25 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BACKGROUND: #ccffff; BORDER-LEFT: silver; COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" x:str=""></TD><TD class=xl25 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BACKGROUND: #ccffff; BORDER-LEFT: silver; COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" x:str=""></TD><TD class=xl45 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BACKGROUND: #ccffff; BORDER-LEFT: silver; COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" x:str=""></TD><TD class=xl46 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" align=right x:num="39845">1</TD><TD class=xl26 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" align=right x:num="39846">2</TD><TD class=xl25 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" align=right x:num="39847">3</TD><TD class=xl25 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" align=right x:num="39848">4</TD><TD class=xl25 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" align=right x:num="39849">5</TD><TD class=xl25 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" align=right x:num="39850">6</TD><TD class=xl45 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" align=right x:num="39851">7</TD><TD class=xl46 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: silver; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" align=right x:num="39852">8</TD></TR><TR style="HEIGHT: 18.75pt; mso-height-source: userset" height=25><TD class=xl36 style="BORDER-RIGHT: #e2e2e2; BORDER-TOP: windowtext; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 18.75pt; BACKGROUND-COLOR: white" height=25></TD><TD class=xl27 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl28 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl28 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl28 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl28 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl47 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl48 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl29 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl28 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl28 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl28 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl28 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl47 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl48 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD></TR><TR style="HEIGHT: 18.75pt; mso-height-source: userset" height=25><TD class=xl37 style="BORDER-RIGHT: #e2e2e2; BORDER-TOP: silver; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 18.75pt; BACKGROUND-COLOR: white" height=25></TD><TD class=xl30 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl49 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl50 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl32 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl49 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl50 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD></TR><TR style="HEIGHT: 18.75pt; mso-height-source: userset" height=25><TD class=xl37 style="BORDER-RIGHT: #e2e2e2; BORDER-TOP: silver; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 18.75pt; BACKGROUND-COLOR: white" height=25></TD><TD class=xl30 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl49 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl50 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl32 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl31 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl49 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl50 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #ffff99"></TD></TR><TR style="HEIGHT: 18.75pt; mso-height-source: userset" height=25><TD class=xl38 style="BORDER-RIGHT: #e2e2e2; BORDER-TOP: silver; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: #e2e2e2; HEIGHT: 18.75pt; BACKGROUND-COLOR: white" height=25></TD><TD class=xl33 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl34 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl34 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl34 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl34 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl51 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl52 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl35 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: #e2e2e2; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl34 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl34 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl34 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl34 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: white"></TD><TD class=xl51 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl52 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: #e2e2e2; BACKGROUND-COLOR: #ffff99"></TD></TR></TBODY></TABLE>

(Although not nescessarily that specific (and frankly pretty horrible) shade of green).

I have a list of all the HTML codes, palette numbers and hex codes for all the excel colours.

If anyone can help, that would be much appreciated.

Cheers,

RayJay

(P.S.) I'm using Excel 2003.

 

[MickG]

Hi, Try this:-
The Code will colour the appropriate Range Based on the Month (Name Like March 2009) in Column "A" and the Day number in the corresponding row.
The address of the Current "Coloured" range is stored in Range("HZ1") and
If you place this code in a Workbook open" Event or similar, the First line clears the previous Coloured Date Range, and then the code inserts the New Coloured range Based on todays Date.

Sub rev()
Dim Rng As Range, Dn As Range, Ac As Range, m
Dim ACRng As Range, Rw1, Rw2, RRW1, R, ColCl
 Set Rng = Range(Range("A1"), Range("A" & Rows.Count).End(xlUp))
    If Range("HZ1") <> "" Then Range(Range("HZ1")).Interior.ColorIndex = xlNone
For Each Dn In Rng
    If InStr(Dn, MonthName(Month(Date))) Then
        Rw1 = Dn.Address
        RRW1 = Dn.Row
        R = Split(Dn.Address, "$")(2)
   Set ACRng = Range(Range(Rw1), Cells(R, Columns.Count).End(xlToLeft))
        For Each Ac In ACRng
            If Ac.Value = Day(Date) Then
                ColCl = Ac.Column
            End If
        Next Ac
End If

If InStr(Dn.Value, MonthName(Month(Date) + 1)) Then
    Rw2 = Dn.Offset(-1).Row
    Else
Rw2 = RRW1 + 5
End If
Next Dn
With Range(Cells(RRW1, ColCl), Cells(Rw2, ColCl))
    .Interior.ColorIndex = 4
    Range("HZ1").Value = .Address
End With
End Sub

Mick

 

[earldunning]

Here is an idea that just worked for me without using code.

Change the 1,2,3, etc to the actual day. For example 1/1/09, 1/2/09
(just put the first one in and make the second one 1+ first) etc.

Then highlight the dates and go to format/cells and pick custom. put in "d" only.
This will make the dates appear as only the day.

Then, do a conditional format using this formula in E1:
=IF(E$1=TODAY(),1,0) choose the pattern color you want using hte format button.

Then copy that cell and paste special / formats only to all others for that month. Do the same for the other months by just changing the reference "E$1" to "E$6" for example for Feb.

This highlights just today.

 

[RayJay]

Hey Mick,

Thanks for the reply - I was wondering - could you just explain what all the variables mean (i.e.) so I can change it to start on today's date and change what colour it gets highlighted in? (Sorry - I'm not too great with VBA/macros)

Cheers,

RayJay

 

[RayJay]

Thanks Earl, but I also need to write in the cells, and I would like for all 5 cells associated with the date to be highlighted without there being a formula in them.

But thanks very much for the idea - I shall bear it in mind for the future and simplified calendars!

RayJay

 

[earldunning]

RayJay,
Thats using conditional formatting. There is no formula in the cell.
You can put whatever you want in them, they are empty.

Conditional formatting puts a formula in the background.
Follow the steps I put in.
The key is to use formats/conditional formatting where I put "do a conditional format."

 

[RayJay]

Of course!

However, how would I get it to change the colour of the 4 cells below it too? Because I've tried this formula:

=IF($AH$23=TODAY(),($AH$23:$AH$27=1),($AH$23:$AH$27=0))

(Since todays date is located at AH23, and so I'm trying to colour it and the four cells below it)

Cheers,

RayJay

 

[earldunning]

Look at the formula I used in my first post.
You use conditional formatting for all the cells. By setting it up properly in the first cell a copy /pastespecial formats works.

For example: if E1 is 1/1/09
=IF(E$1=TODAY(),1,0)
Use that for cell E1.
Then copy it for all of January and use paste special format only.

Then for February replace the 1 with 6 and copy and paste it for feb.
etc.

It will take only a few minutes to complete the whole thing.

 

[RayJay]

Of course!!

Thank you very much Earl!

RayJay

 

[MickG]

Hi, The code will always use todays Date and find it in your Sheet.
Regards Mick