Need VBA for Conditional Formatting

A

ADeYoung

Board Regular
Joined
Jun 28, 2004
Messages
113
I have 8 phases, each a different color with start and end dates. I need VBA to conditionally format the "calendar" cells based on the dates in the phase list. Any help is appreciated. Here is what it looks like.

<SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis/colo/popup.js"></SCRIPT><CENTER><TABLE cellSpacing=0 cellPadding=0 align=center><TBODY><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=#0c266b colSpan=33><TABLE width="100%" align=center border=0><TBODY><TR><TD align=left><FONT color=white>Microsoft Excel - 2008 Plan Schedule.xls</FONT></TD><TD style="FONT-SIZE: 9pt; COLOR: #ffffff; FONT-FAMILY: caption" align=right>___Running: xl2000 : OS = Windows XP </FONT></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; HEIGHT: 25px" bgColor=#d4d0c8 colSpan=33><TABLE width="100%" align=center border=0 VALIGN="MIDDLE"><TBODY><TR><TD style="FONT-SIZE: 10pt; COLOR: #000000; FONT-FAMILY: caption">(<U>F</U>)ile (<U>E</U>)dit (<U>V</U>)iew (<U>I</U>)nsert (<U>O</U>)ptions (<U>T</U>)ools (<U>D</U>)ata (<U>W</U>)indow (<U>H</U>)elp (<U>A</U>)bout</TD><TD vAlign=center align=right><FORM name=formCb755237><INPUT onclick='window.clipboardData.setData("Text",document.formFb078704.sltNb935705.value);' type=button value="Copy Formula" name=btCb873980></FORM></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=white colSpan=33><TABLE border=0><TBODY><TR><FORM name=formFb078704><TD style="WIDTH: 60px" align=middle bgColor=white><SELECT onchange="document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value" name=sltNb935705><OPTION value==AG19+1 selected>K25<OPTION value==K25+1>L25<OPTION value==L25+1>M25<OPTION value==M25+1>N25<OPTION value==N25+1>O25<OPTION value==O25+1>P25<OPTION value==P25+1>Q25<OPTION value==M29+1>V25<OPTION value==V25+1>W25<OPTION value==W25+1>X25<OPTION value==X25+1>Y25<OPTION value==X29+1>AG25<OPTION value==Q25+1>K26<OPTION value==K26+1>L26<OPTION value==L26+1>M26<OPTION value==M26+1>N26<OPTION value==N26+1>O26<OPTION value==O26+1>P26<OPTION value==P26+1>Q26<OPTION value==Y25+1>S26<OPTION value==S26+1>T26<OPTION value==T26+1>U26<OPTION value==U26+1>V26<OPTION value==V26+1>W26<OPTION value==W26+1>X26<OPTION value==X26+1>Y26<OPTION value==AG25+1>AA26<OPTION value==AA26+1>AB26<OPTION value==AB26+1>AC26<OPTION value==AC26+1>AD26<OPTION value==AD26+1>AE26<OPTION value==AE26+1>AF26<OPTION value==AF26+1>AG26<OPTION value==Q26+1>K27<OPTION value==K27+1>L27<OPTION value==L27+1>M27<OPTION value==M27+1>N27<OPTION value==N27+1>O27<OPTION value==O27+1>P27<OPTION value==P27+1>Q27<OPTION value==Y26+1>S27<OPTION value==S27+1>T27<OPTION value==T27+1>U27<OPTION value==U27+1>V27<OPTION value==V27+1>W27<OPTION value==W27+1>X27<OPTION value==X27+1>Y27<OPTION value==AG26+1>AA27<OPTION value==AA27+1>AB27<OPTION value==AB27+1>AC27<OPTION value==AC27+1>AD27<OPTION value==AD27+1>AE27<OPTION value==AE27+1>AF27<OPTION value==AF27+1>AG27<OPTION value==Q27+1>K28<OPTION value==K28+1>L28<OPTION value==L28+1>M28<OPTION value==M28+1>N28<OPTION value==N28+1>O28<OPTION value==O28+1>P28<OPTION value==P28+1>Q28<OPTION value==Y27+1>S28<OPTION value==S28+1>T28<OPTION value==T28+1>U28<OPTION value==U28+1>V28<OPTION value==V28+1>W28<OPTION value==W28+1>X28<OPTION value==X28+1>Y28<OPTION value==AG27+1>AA28<OPTION value==AA28+1>AB28<OPTION value==AB28+1>AC28<OPTION value==AC28+1>AD28<OPTION value==AD28+1>AE28<OPTION value==AE28+1>AF28<OPTION value==AF28+1>AG28<OPTION value==Q28+1>K29<OPTION value==K29+1>L29<OPTION value==L29+1>M29<OPTION value==Y28+1>S29<OPTION value==S29+1>T29<OPTION value==T29+1>U29<OPTION value==U29+1>V29<OPTION value==V29+1>W29<OPTION value==W29+1>X29<OPTION value==AG28+1>AA29<OPTION value==AA29+1>AB29<OPTION value==AB29+1>AC29<OPTION value==AC29+1>AD29<OPTION value==AD29+1>AE29<OPTION value==AE29+1>AF29<OPTION value==AF29+1>AG29<OPTION value==AG29+1>AA30<OPTION value==AA30+1>L35<OPTION value==L35+1>M35<OPTION value==M35+1>N35<OPTION value==N35+1>O35<OPTION value==O35+1>P35<OPTION value==P35+1>Q35<OPTION value==N39+1>W35<OPTION value==W35+1>X35<OPTION value==X35+1>Y35<OPTION value==X39+1>AG35<OPTION value==Q35+1>K36<OPTION value==K36+1>L36<OPTION value==L36+1>M36<OPTION value==M36+1>N36<OPTION value==N36+1>O36<OPTION value==O36+1>P36<OPTION value==P36+1>Q36<OPTION value==Y35+1>S36<OPTION value==S36+1>T36<OPTION value==T36+1>U36<OPTION value==U36+1>V36<OPTION value==V36+1>W36<OPTION value==W36+1>X36<OPTION value==X36+1>Y36<OPTION value==AG35+1>AA36<OPTION value==AA36+1>AB36<OPTION value==AB36+1>AC36<OPTION value==AC36+1>AD36<OPTION value==AD36+1>AE36<OPTION value==AE36+1>AF36<OPTION value==AF36+1>AG36<OPTION value==Q36+1>K37<OPTION value==K37+1>L37<OPTION value==L37+1>M37<OPTION value==M37+1>N37<OPTION value==N37+1>O37<OPTION value==O37+1>P37<OPTION value==P37+1>Q37<OPTION value==Y36+1>S37<OPTION value==S37+1>T37<OPTION value==T37+1>U37<OPTION value==U37+1>V37<OPTION value==V37+1>W37<OPTION value==W37+1>X37<OPTION value==X37+1>Y37<OPTION value==AG36+1>AA37<OPTION value==AA37+1>AB37<OPTION value==AB37+1>AC37<OPTION value==AC37+1>AD37<OPTION value==AD37+1>AE37<OPTION value==AE37+1>AF37<OPTION value==AF37+1>AG37<OPTION value==Q37+1>K38<OPTION value==K38+1>L38<OPTION value==L38+1>M38<OPTION value==M38+1>N38<OPTION value==N38+1>O38<OPTION value==O38+1>P38<OPTION value==P38+1>Q38<OPTION value==Y37+1>S38<OPTION value==S38+1>T38<OPTION value==T38+1>U38<OPTION value==U38+1>V38<OPTION value==V38+1>W38<OPTION value==W38+1>X38<OPTION value==X38+1>Y38<OPTION value==AG37+1>AA38<OPTION value==AA38+1>AB38<OPTION value==AB38+1>AC38<OPTION value==AC38+1>AD38<OPTION value==AD38+1>AE38<OPTION value==AE38+1>AF38<OPTION value==AF38+1>AG38<OPTION value==Q38+1>K39<OPTION value==K39+1>L39<OPTION value==L39+1>M39<OPTION value==M39+1>N39<OPTION value==Y38+1>S39<OPTION value==S39+1>T39<OPTION value==T39+1>U39<OPTION value==U39+1>V39<OPTION value==V39+1>W39<OPTION value==W39+1>X39<OPTION value==AG38+1>AA39<OPTION value==AA39+1>AB39<OPTION value==AB39+1>AC39<OPTION value==AC39+1>AD39<OPTION value==AD39+1>AE39<OPTION value==AE39+1>AF39<OPTION value==AF39+1>AG39<OPTION value==AG39+1>AA40<OPTION value==AA40+1>AB40</OPTION></SELECT></TD><TD align=right width="3%" bgColor=#d4d0c8>=</TD><TD align=left bgColor=white><INPUT size=80 value==AG19+1 name=txbFb426622></TD></FORM></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%">
</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>B</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>C</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>D</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>E</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>F</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>G</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>H</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>I</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>J</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>K</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>L</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>M</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>N</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>O</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>P</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>Q</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>R</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>S</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>T</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>U</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>V</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>W</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>X</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>Y</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>Z</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>AA</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>AB</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>AC</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>AD</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>AE</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>AF</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>AG</CENTER></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>23</CENTER></TD><TD style="BORDER-RIGHT: #c0c0c0 2pt solid; BORDER-TOP: #c0c0c0 2pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #c0c0c0 2pt solid; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 2pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left" colSpan=4>PLAN PHASES</TD><TD style="BORDER-RIGHT: #c0c0c0 2pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #c0c0c0 2pt solid; BORDER-TOP: #c0c0c0 2pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 2pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">START DATE</TD><TD style="BORDER-RIGHT: #c0c0c0 2pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #c0c0c0 2pt solid; BORDER-TOP: #c0c0c0 2pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 2pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">END DATE</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center" colSpan=7>July</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center" colSpan=7>August</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center" colSpan=7>September</TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>24</CENTER></TD><TD style="BORDER-RIGHT: #c0c0c0 2pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; BORDER-LEFT: #c0c0c0 2pt solid; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 2pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ff99cc; TEXT-ALIGN: left" colSpan=4 rowSpan=2>PHASE 1</U></TD><TD style="BORDER-RIGHT: #c0c0c0 2pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #c0c0c0 2pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 2pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center" rowSpan=2> </TD><TD style="BORDER-RIGHT: #c0c0c0 2pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #c0c0c0 2pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 2pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center" rowSpan=2> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">S</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">M</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">T</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">W</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">T</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">F</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">S</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">S</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">M</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">T</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">W</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">T</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">F</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">S</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">S</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">M</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">T</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">W</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">T</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">F</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">S</TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>25</CENTER></TD><TD style="BORDER-RIGHT: #c0c0c0 2pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #c0c0c0 2pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">38</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">1</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">3</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">4</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">5</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">6</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">7</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">1</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">3</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">4</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">1</FONT></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>26</CENTER></TD><TD style="BORDER-RIGHT: #c0c0c0 2pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; BORDER-LEFT: #c0c0c0 2pt solid; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 2pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffcc99; TEXT-ALIGN: left" colSpan=4 rowSpan=2>PHASE 2</U></TD><TD style="BORDER-RIGHT: #c0c0c0 2pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #c0c0c0 2pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 2pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center" rowSpan=2> </TD><TD style="BORDER-RIGHT: #c0c0c0 2pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #c0c0c0 2pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 2pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center" rowSpan=2> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">8</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">9</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">10</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">11</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">12</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">13</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">14</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">5</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">6</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">7</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">8</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">9</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">10</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">11</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">3</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">4</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">5</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">6</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">7</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">8</FONT></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>27</CENTER></TD><TD style="BORDER-RIGHT: #c0c0c0 2pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #c0c0c0 2pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">40</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">15</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">16</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">17</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">18</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">19</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">20</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">21</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">12</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">13</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">14</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">15</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">16</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">17</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">18</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">9</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">10</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">11</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">12</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">13</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">14</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">15</FONT></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>28</CENTER></TD><TD style="BORDER-RIGHT: #c0c0c0 2pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; BORDER-LEFT: #c0c0c0 2pt solid; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 2pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffff99; TEXT-ALIGN: left" colSpan=4 rowSpan=2>PHASE 3</U></TD><TD style="BORDER-RIGHT: #c0c0c0 2pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #c0c0c0 2pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 2pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center" rowSpan=2> </TD><TD style="BORDER-RIGHT: #c0c0c0 2pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #c0c0c0 2pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 2pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center" rowSpan=2> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">22</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">23</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">24</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">25</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">26</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">27</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">28</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">19</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">20</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">21</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">22</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">23</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">24</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">25</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">16</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">17</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">18</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">19</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">20</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">21</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">22</FONT></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>29</CENTER></TD><TD style="BORDER-RIGHT: #c0c0c0 2pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #c0c0c0 2pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">36</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">29</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">30</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">31</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN:
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Sort by date Sort by votes
I do a very similar thing in a calender that tracks my vacation, travel, etc by color.

you will need to add a comparison of the calendar day to the start and end dates, but that should not be too difficult.

This is unclean, because i had not learned to use "with" at the time - but it works.

I include all the code, i set colors and patterns both.

My ranges are, of course different from yours - i add comments to say what they are.

Chaz

Option Explicit
Option Base 1
Sub Update()
'
' Update Macro
'
' Keyboard Shortcut: Ctrl+Shift+U
'
Dim r As Range, dd As Range, cell As Range, hol As Range, vac As Range, trv As Range, d As Range
Dim i As Integer, j As Variant, k(8) As Integer, n As Integer, m As Integer
Dim cc As Variant, mydate1 As Variant, mydate2 As Variant, sick As Range
Dim qq As Variant

' cc = Array(16751052, 16711935, 16764057, 52377, 13434828, 16776960, 10092543, 65535)
cc = Array(17, 12, 15, 9, -4125, -4121, -4126, 1)

For i = 1 To 8
k(i) = 0
Next i

' r is the calendar dates, one range per month
Set r = ActiveSheet.Range("b4:f9,i4:m9,p4:t9,b12:f17,i12:m17,p12:t17,b20:f25,i20:m25,p20:t25,b28:f33,i28:m33,p28:t33")
' holidays are next
Set hol = ActiveSheet.Range("y25:y38")
' then vacation
Set vac = ActiveSheet.Range("ab9:ab37")
' then travel
Set trv = ActiveSheet.Range("ae9:ae22")
Set sick = ActiveSheet.Range("ae24:ae32")
' excused
Set d = ActiveSheet.Range("ae36:ae38")

i = 0
n = 0
m = 0
For Each dd In r
dd.Interior.Color = 16777215
dd.Borders.LineStyle = xlContinuous
dd.Borders.Weight = xlThin
dd.Borders.ColorIndex = 2
dd.Interior.Pattern = 1

If dd.Value <> " " Then
dd.Borders.LineStyle = xlContinuous
dd.Borders.Weight = xlThin
dd.Borders.ColorIndex = 15

If dd.Value = Range("y24").Value Then
dd.Interior.Color = 13408767
dd.Borders.LineStyle = xlContinuous
dd.Borders.Weight = xlMedium
dd.Borders.ColorIndex = 3

End If
For Each cell In hol
If dd.Value = cell.Value Then
dd.Interior.Color = 255
i = i + 1
End If
Next cell

For Each cell In vac
' offset(0,1) is a column containing hours. (0,-1) is name of the weekday
j = cell.Offset(0, 1).Value
If j = 0 Then
cell.Offset(0, -1).Interior.Color = 16751052
cell.Offset(0, 1).Interior.Color = 16751052
cell.Interior.Color = 16751052
Else
If dd.Value = cell.Value Then
If j <> 0 Then
k(j) = k(j) + 1
If j = 8 Then
dd.Interior.Color = 16751052
cell.Offset(0, -1).Interior.Color = 16751052
cell.Offset(0, 1).Interior.Color = 16751052
cell.Interior.Color = 16751052
Else
dd.Interior.Color = 16777215
dd.Interior.PatternColor = 16751052
dd.Interior.Pattern = cc(j)
cell.Offset(0, -1).Interior.Color = 16777215
cell.Offset(0, -1).Interior.PatternColor = 16751052
cell.Offset(0, -1).Interior.Pattern = cc(j)
cell.Offset(0, 1).Interior.Color = 16777215
cell.Offset(0, 1).Interior.PatternColor = 16751052
cell.Offset(0, 1).Interior.Pattern = cc(j)
cell.Interior.Color = 16777215
cell.Interior.PatternColor = 16751052
cell.Interior.Pattern = cc(j)
End If
End If
End If
End If
Next cell

For Each cell In trv
If dd.Value = cell.Value Then
n = n + 1
dd.Interior.Color = 52479
End If
Next cell

For Each cell In sick
' If dd.Value = cell.Value Then
' dd.Interior.Color = 65280
' End If
j = cell.Offset(0, 1).Value
If j = 0 Then
cell.Offset(0, -1).Interior.Color = 65280
cell.Offset(0, 1).Interior.Color = 65280
cell.Interior.Color = 65280
Else
If dd.Value = cell.Value Then
If j <> 0 Then
If j = 8 Then
dd.Interior.Color = 65280
cell.Offset(0, -1).Interior.Color = 65280
cell.Offset(0, 1).Interior.Color = 65280
cell.Interior.Color = 65280
Else
dd.Interior.Color = 16777215
dd.Interior.PatternColor = 65280
dd.Interior.Pattern = cc(j)
cell.Offset(0, -1).Interior.Color = 16777215
cell.Offset(0, -1).Interior.PatternColor = 65280
cell.Offset(0, -1).Interior.Pattern = cc(j)
cell.Offset(0, 1).Interior.Color = 16777215
cell.Offset(0, 1).Interior.PatternColor = 65280
cell.Offset(0, 1).Interior.Pattern = cc(j)
cell.Interior.Color = 16777215
cell.Interior.PatternColor = 65280
cell.Interior.Pattern = cc(j)
End If
End If
End If
End If
Next cell

For Each cell In d
If dd.Value = cell.Value Then
m = m + 1
dd.Interior.Color = 8421504
End If
Next cell

End If
Next dd

Range("j35").Value = i

qq = Array("u38", "u37", "u36", "u35", "p38", "p37", "p36", "p35")

Set cell = Range("p34")
For i = 1 To 4
If i = 1 Then
cell.Offset(i, 0).Interior.Color = 16751052
Else
cell.Offset(i, 0).Interior.Color = 16777215
cell.Offset(i, 0).Interior.PatternColor = 16751052
cell.Offset(i, 0).Interior.Pattern = cc(9 - i)
cell.Offset(i, 0).Value = k(9 - i)
End If
Next i
Set cell = Range("u30")
For i = 5 To 8
cell.Offset(i, 0).Interior.Color = 16777215
cell.Offset(i, 0).Interior.PatternColor = 16751052
cell.Offset(i, 0).Interior.Pattern = cc(9 - i)
cell.Offset(i, 0).Value = k(9 - i)
Next i
Range("p35").Value = k(8)
Range("p36").Value = k(7)
Range("p37").Value = k(6)
Range("p38").Value = k(5)
Range("u35").Value = k(4)
Range("u36").Value = k(3)
Range("u37").Value = k(2)
Range("u38").Value = k(1)

Range("j36").Value = n

Range("j37").Value = m

mydate1 = "12-31-" & Range("v2").Text

mydate2 = Date$

If ((365 * year(mydate1) + 12 * Month(mydate1) + Day(mydate1)) > (365 * year(mydate2) + 12 * Month(mydate2) + Day(mydate2))) Then mydate1 = mydate2

'dummy = MsgBox(" mydate1 value is " & mydate1, vbOKOnly)

Range("a35").Value = "Updated " & MonthName(DatePart("m", mydate1)) & " " & DatePart("d", mydate1) & ", " & DatePart("yyyy", mydate1)

End Sub
 
Upvote 0
Thanks Chaz, but even with changing the ranges, etc, it is not working. For some reason I can't get it to look at the "If date is between start and end".
Any other suggestions?
 
Upvote 0
Maybe the issue is the content of the calendar day cells. I display those as integer values. to constuct a valid date for comparison with the start date, you would have to do something like (and i am only giving a general idea of the procedure, not the exact calls etc that will be needed)

dim daytocompare as string

daytocompare = text(month) & "/" & text(cell.value) & "/" & text(year)

this will stuff a string like 3/15/2007 into the string

then say if date(cell containing start) <= date(stringtocompare) and date(stringtocompare) <= date(cell containing end) do colors

let me know if that helps
 
Upvote 0
I tried to make this as simple as possible but I think there is an issue with my IF Statement. What am I missing here??

<font face=Courier New>
<SPAN style="color:#00007F">Private</SPAN> <SPAN style="color:#00007F">Sub</SPAN> color_chnge()
    
    <SPAN style="color:#00007F">Dim</SPAN> Cell <SPAN style="color:#00007F">As</SPAN> Range
    <SPAN style="color:#00007F">Dim</SPAN> Rng1 <SPAN style="color:#00007F">As</SPAN> Range
    
    <SPAN style="color:#00007F">On</SPAN> <SPAN style="color:#00007F">Error</SPAN> <SPAN style="color:#00007F">Resume</SPAN> <SPAN style="color:#00007F">Next</SPAN>
    <SPAN style="color:#00007F">Set</SPAN> Rng1 = Range("j5:af40")
    <SPAN style="color:#00007F">On</SPAN> <SPAN style="color:#00007F">Error</SPAN> <SPAN style="color:#00007F">GoTo</SPAN> 0
    Rng1.Select
    <SPAN style="color:#00007F">For</SPAN> <SPAN style="color:#00007F">Each</SPAN> Cell <SPAN style="color:#00007F">In</SPAN> Rng1
    <SPAN style="color:#00007F">Date</SPAN> = Cell.Value
    <SPAN style="color:#00007F">If</SPAN> <SPAN style="color:#00007F">Date</SPAN> >= Cell("g24") And <SPAN style="color:#00007F">Date</SPAN> <= Cell("h24") <SPAN style="color:#00007F">Then</SPAN> ActiveCell.Interior.ColorIndex = 25
    <SPAN style="color:#00007F">Else</SPAN>
    ActiveCell.Interior.ColorIndex = 6
    <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN>
    <SPAN style="color:#00007F">Next</SPAN>
    
    <SPAN style="color:#00007F">If</SPAN> <SPAN style="color:#00007F">Date</SPAN> >= Cell("g26") And <SPAN style="color:#00007F">Date</SPAN> <= Cell("h26") <SPAN style="color:#00007F">Then</SPAN> ActiveCell.Interior.ColorIndex = 40
    <SPAN style="color:#00007F">Else</SPAN>
    ActiveCell.Interior.ColorIndex = 6
    <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN>
    <SPAN style="color:#00007F">Next</SPAN>
    
    <SPAN style="color:#00007F">If</SPAN> <SPAN style="color:#00007F">Date</SPAN> >= Cell("g28") And <SPAN style="color:#00007F">Date</SPAN> <= Cell("h28") <SPAN style="color:#00007F">Then</SPAN> ActiveCell.Interior.ColorIndex = 36
    <SPAN style="color:#00007F">Else</SPAN>
    ActiveCell.Interior.ColorIndex = 6
    <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN>
    <SPAN style="color:#00007F">Next</SPAN>
    
    <SPAN style="color:#00007F">If</SPAN> <SPAN style="color:#00007F">Date</SPAN> >= Cell("g30") And <SPAN style="color:#00007F">Date</SPAN> <= Cell("h30") <SPAN style="color:#00007F">Then</SPAN> ActiveCell.Interior.ColorIndex = 35
    <SPAN style="color:#00007F">Else</SPAN>
    ActiveCell.Interior.ColorIndex = 6
    <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN>
    <SPAN style="color:#00007F">Next</SPAN>
    
    <SPAN style="color:#00007F">If</SPAN> <SPAN style="color:#00007F">Date</SPAN> >= Cell("g32") And <SPAN style="color:#00007F">Date</SPAN> <= Cell("h32") <SPAN style="color:#00007F">Then</SPAN> ActiveCell.Interior.ColorIndex = 34
    <SPAN style="color:#00007F">Else</SPAN>
    ActiveCell.Interior.ColorIndex = 6
    <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN>
    <SPAN style="color:#00007F">Next</SPAN>
    
    <SPAN style="color:#00007F">If</SPAN> <SPAN style="color:#00007F">Date</SPAN> >= Cell("g34") And <SPAN style="color:#00007F">Date</SPAN> <= Cell("h34") <SPAN style="color:#00007F">Then</SPAN> ActiveCell.Interior.ColorIndex = 37
    ActiveCell.Interior.ColorIndex = 6
    <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN>
    <SPAN style="color:#00007F">Next</SPAN>
    
    <SPAN style="color:#00007F">If</SPAN> <SPAN style="color:#00007F">Date</SPAN> >= Cell("g36") And <SPAN style="color:#00007F">Date</SPAN> <= Cell("h36") <SPAN style="color:#00007F">Then</SPAN> ActiveCell.Interior.ColorIndex = 39
    <SPAN style="color:#00007F">Else</SPAN>
    ActiveCell.Interior.ColorIndex = 6
    <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN>
    <SPAN style="color:#00007F">Next</SPAN>
    
    <SPAN style="color:#00007F">If</SPAN> <SPAN style="color:#00007F">Date</SPAN> >= Cell("g38") And <SPAN style="color:#00007F">Date</SPAN> <= Cell("h38") <SPAN style="color:#00007F">Then</SPAN> ActiveCell.Interior.ColorIndex = 44
    <SPAN style="color:#00007F">Else</SPAN>
    ActiveCell.Interior.ColorIndex = 6
    <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN>
        
    <SPAN style="color:#00007F">Next</SPAN>
    
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN>


</FONT>
[/code]
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Question
Adding a custom message.
Replies
1
Views
455
Micron
M
G
  • Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
862
gvsumich
G
V
  • Solved
How to put a space in this table in VBA?
Replies
1
Views
336
VBAEXCELNew
V
E
  • Question
Query in excel to Outlook mail take rows with name until next name
Replies
0
Views
363
esben
E
R
  • Question
Random
Replies
1
Views
457
Fluff
Fluff

Forum statistics

Threads
1,215,847
Messages
6,127,264
Members
449,372
Latest member
charlottedv

Share this page

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