random colour allocation for a cell

A

ajm

Well-known Member
Joined
Feb 5, 2003
Messages
2,005
Office Version
  1. 365
Platform
  1. Windows
i have a little routine that is used to add new lines to a grid. I want to be able to allocate a colour to one cell at the start of the new line. The idea is to make each consecutive line a different colour so that the grid is easier to read.

has anybody got any ideas how i might get the colour for the new line to not be the same as the colour below and the colour above its final resting place. that is, say the new line ended up between the 17th and 18th lines in the existing table. How could I get a colour that wasn't green and wasn't blue, so that the new line would stand out?
<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=10><TABLE width="100%" align=center border=0><TBODY><TR><TD align=left><FONT color=white>Microsoft Excel - Promo Plan F08 - MASTER1.xls</FONT></TD><TD style="FONT-SIZE: 9pt; COLOR: #ffffff; FONT-FAMILY: caption" align=right>___Running: 11.0 : 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=10><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=10><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==COUNTA(F11:BM11)-COUNTBLANK(F11:BM11) selected>E11<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A11,$B$10)),F$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A11,$B$10)),F$7,0)))'>F11<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A11,$B$10)),G$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A11,$B$10)),G$7,0)))'>G11<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A11,$B$10)),H$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A11,$B$10)),H$7,0)))'>H11<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A11,$B$10)),I$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A11,$B$10)),I$7,0)))'>I11<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A11,$B$10)),J$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A11,$B$10)),J$7,0)))'>J11<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A11,$B$10)),K$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A11,$B$10)),K$7,0)))'>K11<OPTION value==COUNTA(F12:BM12)-COUNTBLANK(F12:BM12)>E12<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A12,$B$10)),F$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A12,$B$10)),F$7,0)))'>F12<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A12,$B$10)),G$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A12,$B$10)),G$7,0)))'>G12<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A12,$B$10)),H$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A12,$B$10)),H$7,0)))'>H12<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A12,$B$10)),I$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A12,$B$10)),I$7,0)))'>I12<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A12,$B$10)),J$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A12,$B$10)),J$7,0)))'>J12<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A12,$B$10)),K$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A12,$B$10)),K$7,0)))'>K12<OPTION value==COUNTA(F13:BM13)-COUNTBLANK(F13:BM13)>E13<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A13,$B$10)),F$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A13,$B$10)),F$7,0)))'>F13<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A13,$B$10)),G$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A13,$B$10)),G$7,0)))'>G13<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A13,$B$10)),H$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A13,$B$10)),H$7,0)))'>H13<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A13,$B$10)),I$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A13,$B$10)),I$7,0)))'>I13<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A13,$B$10)),J$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A13,$B$10)),J$7,0)))'>J13<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A13,$B$10)),K$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A13,$B$10)),K$7,0)))'>K13<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A14,$B$10)),F$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A14,$B$10)),F$7,0)))'>F14<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A14,$B$10)),G$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A14,$B$10)),G$7,0)))'>G14<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A14,$B$10)),H$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A14,$B$10)),H$7,0)))'>H14<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A14,$B$10)),I$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A14,$B$10)),I$7,0)))'>I14<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A14,$B$10)),J$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A14,$B$10)),J$7,0)))'>J14<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A14,$B$10)),K$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A14,$B$10)),K$7,0)))'>K14<OPTION value==COUNTA(F15:BM15)-COUNTBLANK(F15:BM15)>E15<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A15,$B$10)),F$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A15,$B$10)),F$7,0)))'>F15<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A15,$B$10)),G$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A15,$B$10)),G$7,0)))'>G15<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A15,$B$10)),H$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A15,$B$10)),H$7,0)))'>H15<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A15,$B$10)),I$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A15,$B$10)),I$7,0)))'>I15<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A15,$B$10)),J$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A15,$B$10)),J$7,0)))'>J15<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A15,$B$10)),K$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A15,$B$10)),K$7,0)))'>K15<OPTION value==COUNTA(F16:BM16)-COUNTBLANK(F16:BM16)>E16<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A16,$B$10)),F$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A16,$B$10)),F$7,0)))'>F16<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A16,$B$10)),G$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A16,$B$10)),G$7,0)))'>G16<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A16,$B$10)),H$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A16,$B$10)),H$7,0)))'>H16<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A16,$B$10)),I$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A16,$B$10)),I$7,0)))'>I16<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A16,$B$10)),J$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A16,$B$10)),J$7,0)))'>J16<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A16,$B$10)),K$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A16,$B$10)),K$7,0)))'>K16<OPTION value==COUNTA(F17:BM17)-COUNTBLANK(F17:BM17)>E17<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A17,$B$10)),F$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A17,$B$10)),F$7,0)))'>F17<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A17,$B$10)),G$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A17,$B$10)),G$7,0)))'>G17<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A17,$B$10)),H$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A17,$B$10)),H$7,0)))'>H17<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A17,$B$10)),I$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A17,$B$10)),I$7,0)))'>I17<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A17,$B$10)),J$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A17,$B$10)),J$7,0)))'>J17<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A17,$B$10)),K$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A17,$B$10)),K$7,0)))'>K17<OPTION value==COUNTA(F18:BM18)-COUNTBLANK(F18:BM18)>E18<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A18,$B$10)),F$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A18,$B$10)),F$7,0)))'>F18<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A18,$B$10)),G$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A18,$B$10)),G$7,0)))'>G18<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A18,$B$10)),H$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A18,$B$10)),H$7,0)))'>H18<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A18,$B$10)),I$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A18,$B$10)),I$7,0)))'>I18<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A18,$B$10)),J$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A18,$B$10)),J$7,0)))'>J18<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A18,$B$10)),K$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A18,$B$10)),K$7,0)))'>K18<OPTION value==COUNTA(F19:BM19)-COUNTBLANK(F19:BM19)>E19<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A19,$B$10)),F$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A19,$B$10)),F$7,0)))'>F19<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A19,$B$10)),G$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A19,$B$10)),G$7,0)))'>G19<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A19,$B$10)),H$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A19,$B$10)),H$7,0)))'>H19<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A19,$B$10)),I$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A19,$B$10)),I$7,0)))'>I19<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A19,$B$10)),J$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A19,$B$10)),J$7,0)))'>J19<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A19,$B$10)),K$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A19,$B$10)),K$7,0)))'>K19<OPTION value==COUNTA(F20:BM20)-COUNTBLANK(F20:BM20)>E20<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A20,$B$10)),F$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A20,$B$10)),F$7,0)))'>F20<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A20,$B$10)),G$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A20,$B$10)),G$7,0)))'>G20<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A20,$B$10)),H$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A20,$B$10)),H$7,0)))'>H20<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A20,$B$10)),I$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A20,$B$10)),I$7,0)))'>I20<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A20,$B$10)),J$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A20,$B$10)),J$7,0)))'>J20<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A20,$B$10)),K$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A20,$B$10)),K$7,0)))'>K20<OPTION value==COUNTA(F21:BM21)-COUNTBLANK(F21:BM21)>E21<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A21,$B$10)),F$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A21,$B$10)),F$7,0)))'>F21<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A21,$B$10)),G$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A21,$B$10)),G$7,0)))'>G21<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A21,$B$10)),H$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A21,$B$10)),H$7,0)))'>H21<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A21,$B$10)),I$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A21,$B$10)),I$7,0)))'>I21<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A21,$B$10)),J$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A21,$B$10)),J$7,0)))'>J21<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A21,$B$10)),K$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A21,$B$10)),K$7,0)))'>K21<OPTION value==COUNTA(F22:BM22)-COUNTBLANK(F22:BM22)>E22<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A22,$B$10)),F$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A22,$B$10)),F$7,0)))'>F22<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A22,$B$10)),G$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A22,$B$10)),G$7,0)))'>G22<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A22,$B$10)),H$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A22,$B$10)),H$7,0)))'>H22<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A22,$B$10)),I$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A22,$B$10)),I$7,0)))'>I22<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A22,$B$10)),J$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A22,$B$10)),J$7,0)))'>J22<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A22,$B$10)),K$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A22,$B$10)),K$7,0)))'>K22<OPTION value==COUNTA(F23:BM23)-COUNTBLANK(F23:BM23)>E23<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A23,$B$10)),F$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A23,$B$10)),F$7,0)))'>F23<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A23,$B$10)),G$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A23,$B$10)),G$7,0)))'>G23<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A23,$B$10)),H$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A23,$B$10)),H$7,0)))'>H23<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A23,$B$10)),I$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A23,$B$10)),I$7,0)))'>I23<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A23,$B$10)),J$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A23,$B$10)),J$7,0)))'>J23<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A23,$B$10)),K$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A23,$B$10)),K$7,0)))'>K23<OPTION value==COUNTA(F24:BM24)-COUNTBLANK(F24:BM24)>E24<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A24,$B$10)),F$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A24,$B$10)),F$7,0)))'>F24<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A24,$B$10)),G$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A24,$B$10)),G$7,0)))'>G24<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A24,$B$10)),H$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A24,$B$10)),H$7,0)))'>H24<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A24,$B$10)),I$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A24,$B$10)),I$7,0)))'>I24<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A24,$B$10)),J$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A24,$B$10)),J$7,0)))'>J24<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A24,$B$10)),K$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A24,$B$10)),K$7,0)))'>K24<OPTION value==COUNTA(F25:BM25)-COUNTBLANK(F25:BM25)>E25<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A25,$B$10)),F$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A25,$B$10)),F$7,0)))'>F25<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A25,$B$10)),G$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A25,$B$10)),G$7,0)))'>G25<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A25,$B$10)),H$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A25,$B$10)),H$7,0)))'>H25<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A25,$B$10)),I$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A25,$B$10)),I$7,0)))'>I25<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A25,$B$10)),J$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A25,$B$10)),J$7,0)))'>J25<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A25,$B$10)),K$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A25,$B$10)),K$7,0)))'>K25<OPTION value==COUNTA(F26:BM26)-COUNTBLANK(F26:BM26)>E26<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A26,$B$10)),F$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A26,$B$10)),F$7,0)))'>F26<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A26,$B$10)),G$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A26,$B$10)),G$7,0)))'>G26<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A26,$B$10)),H$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A26,$B$10)),H$7,0)))'>H26<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A26,$B$10)),I$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A26,$B$10)),I$7,0)))'>I26<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A26,$B$10)),J$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A26,$B$10)),J$7,0)))'>J26<OPTION value='=IF(ISBLANK(VLOOKUP($S$6,INDIRECT(CONCATENATE($A26,$B$10)),K$7,0)),"",(VLOOKUP($S$6,INDIRECT(CONCATENATE($A26,$B$10)),K$7,0)))'>K26</OPTION></SELECT></TD><TD align=right width="3%" bgColor=#d4d0c8>=</TD><TD align=left bgColor=white><INPUT size=80 value==COUNTA(F11:BM11)-COUNTBLANK(F11:BM11) 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>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></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>11</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; BORDER-TOP: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[1].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">A</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">A</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[4].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; BORDER-TOP: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[5].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[6].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></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>12</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ff6600; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">4</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">B</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">B</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">B</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">B</FONT></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[12].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[13].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></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>13</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #808000; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[15].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[16].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">A</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">A</FONT></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[19].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[20].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></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>14</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #33cccc; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">A</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[22].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[23].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[24].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[25].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[26].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></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>15</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[27].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[28].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[29].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[30].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[31].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[32].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[33].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></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>16</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #333399; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">3</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">A</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[36].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[37].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">A</FONT></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">A</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[40].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></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>17</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #339966; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">4</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">A</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">A</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">A</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">A</FONT></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[46].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[47].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></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>18</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #0000ff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[49].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[50].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">A</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">A</FONT></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[53].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[54].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></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>19</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ff6600; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[55].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[56].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[57].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[58].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[59].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[60].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[61].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></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>20</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #800000; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[62].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[63].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[64].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[65].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[66].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[67].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[68].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></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>21</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ccff99; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">5</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">AE</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">AE</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[72].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[73].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[74].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">AE</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>22</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #000000; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">3</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">BP</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">I</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">I</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[80].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[81].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[82].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></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: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff99; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">5</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">A</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">A</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[86].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[87].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[88].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb078704.sltNb935705.options[89].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
Sort by date Sort by votes
How about?
Code: 
Sub diffcolor()
'insertion row is newrow
If Not newrow = 1 Then x = Cells(newrow - 1, "d").Interior.ColorIndex
y = Cells(newrow + 1, "d").Interior.ColorIndex
Do
z = Int(Rnd * 56) + 1
Cells(newrow, "d").Interior.ColorIndex = z
Loop Until x <> z And y <> z
End Sub
 
Upvote 0
rugila, where are you putting the macro? into a sheet module or normal module?

I am having a hard time fitting it into the following code which grabs a "new line" from NewGroupLineFormat, which is a one liner right at the bottom of my page, and copies it into the Opportunity Matrix. Last step is once it has been inserted into the OpMatrix, the range is then sorted alphabetically. so somehow, i have to make the final resting place of the newly inserted row a range called "newrow". This is where i am having trouble because named ranges don't like to be moved. so when do i do the naming? actually, more to the point, how do i assign the variable "newrow" to the latest line in the grid? maybe a find (or something like it) on the name assigned to the naming cell?

here's the relevant part of the the code i am using in the Sheet module to insert the new line: (it will be easier to see if you copy it into notepad or into a blank workbook module)

Code: 
'add new group to Opportunity Matrix

    Worksheets("Opportunity Matrix").Activate
    ActiveSheet.Unprotect ("password")
'add the Group Name to the first cell in the new line range
    Application.Goto Reference:="NewGroupNameCell"
    With ActiveCell
        .Value = AddSheetQuestion
        .Value = Replace(StrConv(AddSheetQuestion, vbProperCase), " ", "")
    End With
'pick up the rwhole range
    Application.Goto Reference:="NewGroupLineFormat"
    Selection.Copy
'insert new line into OpMatrix above last empty line in grid
    Application.Goto Reference:="NewGroupLine"
    Selection.Insert Shift:=xlDown
    Worksheets("Opportunity Matrix").Range("OpMatrix").Sort Key1:=Worksheets("Opportunity Matrix").Range("$b$11")
    ActiveSheet.Protect ("password")
 
Upvote 0
still trying to test your macro relative to what i want to use it for. I have come up with the following code to try and test it but am coming unstuck.
Code: 
Sub trythis()
Dim newname As Range
Dim newrow As Range


newname = Range("NewGroupNameCell").Value
With Worksheets("Opportunity Matrix").Range("OpMatrix")
Set newrow = .Find(what:=newname)
End With
'insertion row is newrow
If Not newrow = 1 Then x = Cells(newrow - 1, "d").Interior.ColorIndex
y = Cells(newrow + 1, "d").Interior.ColorIndex
Do
z = Int(Rnd * 56) + 1
Cells(newrow, "d").Interior.ColorIndex = z
Loop Until x <> z And y <> z
End Sub

the code is falling over on
Code: 
x = Cells(newrow - 1, "d").Interior.ColorIndex

any ideas?
 
Upvote 0
hi,

try declaring newrow as integer, not as range, because it was supposed to be just the number of a row, not the row itself.
 
Upvote 0
this worked instead:
Code: 
Sub trythis()
Dim newname As String

newname = Range("NewGroupNameCell").Value
Worksheets("Opportunity Matrix").Range("OpMatrix").Find(what:=newname).Offset(rowOffset:=0, columnOffset:=2).Activate
  'insertion row is newrow
If Not ActiveCell = 1 Then x = ActiveCell.Offset(rowOffset:=-1, columnOffset:=0).Interior.ColorIndex
y = ActiveCell.Offset(rowOffset:=1, columnOffset:=0).Interior.ColorIndex
Do
z = Int(Rnd * 56) + 1
ActiveCell.Interior.ColorIndex = z
Loop Until x <> z And y <> z

End Sub

thanks for getting me started Rugila. Much appreciated
 
Upvote 0
Just a minor point regarding the do ... loop in the randomisation bit of the code.

My original suggestion
Code: 
Do
z = Int(Rnd * 56) + 1
ActiveCell.Interior.ColorIndex = z
Loop Until x <> z And y <> z
is somewhat inefficient, even tho' it works.

Probably better is
Code: 
Do
z = Int(Rnd * 56) + 1
Loop Until x <> z And y <> z
ActiveCell.Interior.ColorIndex = z
since it only needs to color the new cell once, rather than a random number of times.
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Question
Adding a custom message.
Replies
1
Views
421
Micron
M
G
  • Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
816
gvsumich
G
E
  • Question
Query in excel to Outlook mail take rows with name until next name
Replies
0
Views
344
esben
E
R
  • Question
Random
Replies
1
Views
440
Fluff
Fluff
E
  • Question
Create mails with table - standard header specific row
Replies
1
Views
928
esben
E

Forum statistics

Threads
1,214,583
Messages
6,120,378
Members
448,955
Latest member
BatCoder

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