Highlight todays date in an excel calendar

RayJay

Board Regular
Joined
Feb 24, 2009
Messages
69
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.
 
Last edited:
Hi, If you unsure how to use this code, then try this:-
Right click the sheet Tab, Select "View Code" VB Window appears.
Paste the entire code below into the VB Window.
Close the Vb window.
Move to another sheet, when reopen the original sheet, Todays Date Range should be colourd "Green".
You will see this at the bottom of the code.
---Interior.colorindex = 4
change to suit.
If you've sorted this With Con/Formatting then Keep this for ref.
Regards Mick
 
Upvote 0

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
When I run this macro, I get an "application-defined or object-defined error", and in the debug, this line
Code:
With Range(Cells(RRW1, ColCl), Cells(Rw2, ColCl))
is highlighted...

Know what's up?
 
Upvote 0
Hi, Are you sure you have March the 27th in your sheet.
If I remove todays Date, I get exactly the same Error.
The sheet should be laid out as your Original post but with ALL the Days of the Month.
Regards Mick
 
Upvote 0
I have that - I have every date in the year, and it's definitely set as the date, because the conditional formatting bit works...
 
Upvote 0
Hi, Have a look at this Example:-
The code is stored in the "Sheet Activate" Event in sheet(1).
If you remove the "Green Line from" March 30th, then change sheets and reactivate sheet (1) the Green Line should reapear. Check out the difference between your sheet and Sheet(1).
www.4shared.com/file/95756923/48ed5e5a/Calendar.html
Regards Mick
 
Last edited:
Upvote 0
Hi, A few things. The code needed to Go in An Event Procedure rather than a "Module" and because you only have one sheet I put it in w Workbook Open event , so the Colouring takes place When you Open the File. Hope thats OK.
Other himgs, your Months /Years were in Column "B" Code searched column "A", and the Months Days were actually Dates. Hopefullly this is Now sorted as below.
Calendar_2009a.xls

Regards Mick
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,556
Messages
6,114,284
Members
448,562
Latest member
Flashbond

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top