Conditional Formatting Help Please

[Rockhopper3]

Hello everybody. I need your help yet again. I have a sheet (copied below for viewing) where cells from another sheet are copied into columns S-W. A formula in columns B-G then sorts the information into the appropriate columns, i.e. puts the customer information under the correct sales person. What I need to do is for sales that have been carried over (marked "c/o" in column S) to be highlighted in the correct column for that customer and sales person.

For example.... Sales person Rob (RM) sold and item to customer 1 last month. Customer 1 is displayed in cell B3 and the gross for that customer is in cell C3. I want that line to be highlighted using conditional formatting so that I can see that customer was carried over. from the previous month. I thought I had figured it out, but it would highlight whatever row the information was on in columns S-W. The conditional formatting needs to change depending on if column S has "C/O" in it or not, because I am going to use a similar formatting to mark customers that WILL be carried to the following month.

Here is the sheet. Tahnk you in advance for all of your suggestions.

<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=25><TABLE width="100%" align=center border=0><TBODY><TR><TD align=left><FONT color=white>Microsoft Excel - green book.xlsm</FONT></TD><TD style="FONT-SIZE: 9pt; COLOR: #ffffff; FONT-FAMILY: caption" align=right>___Running: 12.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=25><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=formCb956020><INPUT onclick='window.clipboardData.setData("Text",document.formFb655563.sltNb554840.value);' type=button value="Copy Formula" name=btCb459447></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=25><TABLE border=0><TBODY><TR><FORM name=formFb655563><TD style="WIDTH: 60px" align=middle bgColor=white><SELECT onchange="document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value" name=sltNb554840><OPTION value='=IF(November!AB4="","","c/o")' selected>S2<OPTION value='=IF(November!C4="","",November!C4)'>T2<OPTION value='=IF(November!E4="","",November!E4)'>U2<OPTION value='=IF(November!F4="","",November!F4)'>V2<OPTION value='=IF(November!R4="","",November!R4)'>W2<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A3)),"",INDIRECT("V"&SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A3)))}'>B3<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A3)),"",INDIRECT("W"&SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A3)))}'>C3<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$3,ROW($U$2:$U$203)),$A3)),"",INDIRECT("V"&SMALL(IF($U$2:$U$203=$X$3,ROW($U$2:$U$203)),$A3)))}'>D3<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$3,ROW($U$2:$U$203)),$A3)),"",INDIRECT("W"&SMALL(IF($U$2:$U$203=$X$3,ROW($U$2:$U$203)),$A3)))}'>E3<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A3)),"",INDIRECT("V"&SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A3)))}'>F3<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A3)),"",INDIRECT("W"&SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A3)))}'>G3<OPTION value='=IF(OR(U2:U203<>"RM",U2:U203<>"TB",U2:U203<>"PG"),"",IF(ISERROR(SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A3)),"",INDIRECT("T"&SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A3))))'>H3<OPTION value='=IF(November!AB5="","","c/o")'>S3<OPTION value='=IF(November!C5="","",November!C5)'>T3<OPTION value='=IF(November!E5="","",November!E5)'>U3<OPTION value='=IF(November!F5="","",November!F5)'>V3<OPTION value='=IF(November!R5="","",November!R5)'>W3<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A4)),"",INDIRECT("V"&SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A4)))}'>B4<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A4)),"",INDIRECT("W"&SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A4)))}'>C4<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$3,ROW($U$2:$U$203)),$A4)),"",INDIRECT("V"&SMALL(IF($U$2:$U$203=$X$3,ROW($U$2:$U$203)),$A4)))}'>D4<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$3,ROW($U$2:$U$203)),$A4)),"",INDIRECT("W"&SMALL(IF($U$2:$U$203=$X$3,ROW($U$2:$U$203)),$A4)))}'>E4<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A4)),"",INDIRECT("V"&SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A4)))}'>F4<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A4)),"",INDIRECT("W"&SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A4)))}'>G4<OPTION value='=IF(November!AB6="","","c/o")'>S4<OPTION value='=IF(November!C6="","",November!C6)'>T4<OPTION value='=IF(November!E6="","",November!E6)'>U4<OPTION value='=IF(November!F6="","",November!F6)'>V4<OPTION value='=IF(November!R6="","",November!R6)'>W4<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A5)),"",INDIRECT("V"&SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A5)))}'>B5<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A5)),"",INDIRECT("W"&SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A5)))}'>C5<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$3,ROW($U$2:$U$203)),$A5)),"",INDIRECT("V"&SMALL(IF($U$2:$U$203=$X$3,ROW($U$2:$U$203)),$A5)))}'>D5<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$3,ROW($U$2:$U$203)),$A5)),"",INDIRECT("W"&SMALL(IF($U$2:$U$203=$X$3,ROW($U$2:$U$203)),$A5)))}'>E5<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A5)),"",INDIRECT("V"&SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A5)))}'>F5<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A5)),"",INDIRECT("W"&SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A5)))}'>G5<OPTION value='=IF(November!AB7="","","c/o")'>S5<OPTION value='=IF(November!C7="","",November!C7)'>T5<OPTION value='=IF(November!E7="","",November!E7)'>U5<OPTION value='=IF(November!F7="","",November!F7)'>V5<OPTION value='=IF(November!R7="","",November!R7)'>W5<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A6)),"",INDIRECT("V"&SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A6)))}'>B6<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A6)),"",INDIRECT("W"&SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A6)))}'>C6<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$3,ROW($U$2:$U$203)),$A6)),"",INDIRECT("V"&SMALL(IF($U$2:$U$203=$X$3,ROW($U$2:$U$203)),$A6)))}'>D6<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$3,ROW($U$2:$U$203)),$A6)),"",INDIRECT("W"&SMALL(IF($U$2:$U$203=$X$3,ROW($U$2:$U$203)),$A6)))}'>E6<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A6)),"",INDIRECT("V"&SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A6)))}'>F6<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A6)),"",INDIRECT("W"&SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A6)))}'>G6<OPTION value='=IF(November!AB8="","","c/o")'>S6<OPTION value='=IF(November!C8="","",November!C8)'>T6<OPTION value='=IF(November!E8="","",November!E8)'>U6<OPTION value='=IF(November!F8="","",November!F8)'>V6<OPTION value='=IF(November!R8="","",November!R8)'>W6<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A7)),"",INDIRECT("V"&SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A7)))}'>B7<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A7)),"",INDIRECT("W"&SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A7)))}'>C7<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$3,ROW($U$2:$U$203)),$A7)),"",INDIRECT("V"&SMALL(IF($U$2:$U$203=$X$3,ROW($U$2:$U$203)),$A7)))}'>D7<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$3,ROW($U$2:$U$203)),$A7)),"",INDIRECT("W"&SMALL(IF($U$2:$U$203=$X$3,ROW($U$2:$U$203)),$A7)))}'>E7<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A7)),"",INDIRECT("V"&SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A7)))}'>F7<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A7)),"",INDIRECT("W"&SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A7)))}'>G7<OPTION value='=IF(November!AB9="","","c/o")'>S7<OPTION value='=IF(November!C9="","",November!C9)'>T7<OPTION value='=IF(November!E9="","",November!E9)'>U7<OPTION value='=IF(November!F9="","",November!F9)'>V7<OPTION value='=IF(November!R9="","",November!R9)'>W7<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A8)),"",INDIRECT("V"&SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A8)))}'>B8<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A8)),"",INDIRECT("W"&SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A8)))}'>C8<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$3,ROW($U$2:$U$203)),$A8)),"",INDIRECT("V"&SMALL(IF($U$2:$U$203=$X$3,ROW($U$2:$U$203)),$A8)))}'>D8<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$3,ROW($U$2:$U$203)),$A8)),"",INDIRECT("W"&SMALL(IF($U$2:$U$203=$X$3,ROW($U$2:$U$203)),$A8)))}'>E8<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A8)),"",INDIRECT("V"&SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A8)))}'>F8<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A8)),"",INDIRECT("W"&SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A8)))}'>G8<OPTION value='=IF(November!AB10="","","c/o")'>S8<OPTION value='=IF(November!C10="","",November!C10)'>T8<OPTION value='=IF(November!E10="","",November!E10)'>U8<OPTION value='=IF(November!F10="","",November!F10)'>V8<OPTION value='=IF(November!R10="","",November!R10)'>W8<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A9)),"",INDIRECT("V"&SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A9)))}'>B9<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A9)),"",INDIRECT("W"&SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A9)))}'>C9<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$3,ROW($U$2:$U$203)),$A9)),"",INDIRECT("V"&SMALL(IF($U$2:$U$203=$X$3,ROW($U$2:$U$203)),$A9)))}'>D9<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$3,ROW($U$2:$U$203)),$A9)),"",INDIRECT("W"&SMALL(IF($U$2:$U$203=$X$3,ROW($U$2:$U$203)),$A9)))}'>E9<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A9)),"",INDIRECT("V"&SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A9)))}'>F9<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A9)),"",INDIRECT("W"&SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A9)))}'>G9<OPTION value='=IF(November!AB11="","","c/o")'>S9<OPTION value='=IF(November!C11="","",November!C11)'>T9<OPTION value='=IF(November!E11="","",November!E11)'>U9<OPTION value='=IF(November!F11="","",November!F11)'>V9<OPTION value='=IF(November!R11="","",November!R11)'>W9<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A10)),"",INDIRECT("V"&SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A10)))}'>B10<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A10)),"",INDIRECT("W"&SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A10)))}'>C10<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$3,ROW($U$2:$U$203)),$A10)),"",INDIRECT("V"&SMALL(IF($U$2:$U$203=$X$3,ROW($U$2:$U$203)),$A10)))}'>D10<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$3,ROW($U$2:$U$203)),$A10)),"",INDIRECT("W"&SMALL(IF($U$2:$U$203=$X$3,ROW($U$2:$U$203)),$A10)))}'>E10<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A10)),"",INDIRECT("V"&SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A10)))}'>F10<OPTION value='{=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A10)),"",INDIRECT("W"&SMALL(IF($U$2:$U$203=$X$4,ROW($U$2:$U$203)),$A10)))}'>G10<OPTION value='=IF(November!AB12="","","c/o")'>S10<OPTION value='=IF(November!C12="","",November!C12)'>T10<OPTION value='=IF(November!E12="","",November!E12)'>U10<OPTION value='=IF(November!F12="","",November!F12)'>V10<OPTION value='=IF(November!R12="","",November!R12)'>W10</OPTION></SELECT></TD><TD align=right width="3%" bgColor=#d4d0c8>=</TD><TD align=left bgColor=white><INPUT size=80 value='=IF(November!AB4="","","c/o")' name=txbFb064864 {95919BE0-C436-4eab-8083-096E94826667}='=IF(November!AB4="","","c/o")'></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>A</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>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></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>1</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #0000ff; TEXT-ALIGN: center" colSpan=2>Rob</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ff9900; TEXT-ALIGN: center" colSpan=2>Pete</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: center" colSpan=2>Tony</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #00ffff; TEXT-ALIGN: center" colSpan=2>House</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #00ffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; VERTICAL-ALIGN: middle; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Carried In</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; VERTICAL-ALIGN: middle; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Carry Over</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; VERTICAL-ALIGN: middle; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Sales Person</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; VERTICAL-ALIGN: middle; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Cust. Name</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; VERTICAL-ALIGN: middle; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Gross</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; VERTICAL-ALIGN: middle; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">SP List</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>2</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #0000ff; TEXT-ALIGN: center">Cust. Name</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #0000ff; TEXT-ALIGN: center">Gross</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ff9900; TEXT-ALIGN: center">Cust. Name</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ff9900; TEXT-ALIGN: center">Gross</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: center">Cust. Name</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: center">Gross</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #00ffff; TEXT-ALIGN: center">Cust. Name</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #00ffff; TEXT-ALIGN: center">Gross</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #00ffff; TEXT-ALIGN: center">Sales Person</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">c/o</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb655563.sltNb554840.options[1].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">RM</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Customer 1</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">1234</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">RM</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>3</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">1</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #0000ff; TEXT-ALIGN: left">Customer 1</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #0000ff; TEXT-ALIGN: right">1234</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ff9900; TEXT-ALIGN: left">Customer 4</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ff9900; TEXT-ALIGN: right">4378</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: left">Customer 2</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: right">342</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #00ffff; TEXT-ALIGN: left"><A onclick="document.formFb655563.sltNb554840.options[11].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #00ffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #00ffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb655563.sltNb554840.options[12].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb655563.sltNb554840.options[13].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">TB</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Customer 2</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">342</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">PG</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>4</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">2</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #0000ff; TEXT-ALIGN: left">Customer 3</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #0000ff; TEXT-ALIGN: right">5674</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ff9900; TEXT-ALIGN: left">Customer 6</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ff9900; TEXT-ALIGN: right">9999</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: left">Customer 5</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: right">2323</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #00ffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #00ffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #00ffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb655563.sltNb554840.options[23].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">a</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">RM</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Customer 3</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">5674</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">TB</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>5</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">3</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #0000ff; TEXT-ALIGN: left"><A onclick="document.formFb655563.sltNb554840.options[28].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #0000ff; TEXT-ALIGN: left"><A onclick="document.formFb655563.sltNb554840.options[29].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ff9900; TEXT-ALIGN: left"><A onclick="document.formFb655563.sltNb554840.options[30].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ff9900; TEXT-ALIGN: left"><A onclick="document.formFb655563.sltNb554840.options[31].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: left"><A onclick="document.formFb655563.sltNb554840.options[32].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: left"><A onclick="document.formFb655563.sltNb554840.options[33].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #00ffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #00ffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #00ffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb655563.sltNb554840.options[34].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb655563.sltNb554840.options[35].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">PG</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Customer 4</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">4378</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">TC</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>6</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">4</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #0000ff; TEXT-ALIGN: left"><A onclick="document.formFb655563.sltNb554840.options[39].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #0000ff; TEXT-ALIGN: left"><A onclick="document.formFb655563.sltNb554840.options[40].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ff9900; TEXT-ALIGN: left"><A onclick="document.formFb655563.sltNb554840.options[41].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ff9900; TEXT-ALIGN: left"><A onclick="document.formFb655563.sltNb554840.options[42].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: left"><A onclick="document.formFb655563.sltNb554840.options[43].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: left"><A onclick="document.formFb655563.sltNb554840.options[44].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #00ffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #00ffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #00ffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb655563.sltNb554840.options[45].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">a</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">TB</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Customer 5</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2323</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">MB</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>7</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">5</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #0000ff; TEXT-ALIGN: left"><A onclick="document.formFb655563.sltNb554840.options[50].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #0000ff; TEXT-ALIGN: left"><A onclick="document.formFb655563.sltNb554840.options[51].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ff9900; TEXT-ALIGN: left"><A onclick="document.formFb655563.sltNb554840.options[52].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ff9900; TEXT-ALIGN: left"><A onclick="document.formFb655563.sltNb554840.options[53].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: left"><A onclick="document.formFb655563.sltNb554840.options[54].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: left"><A onclick="document.formFb655563.sltNb554840.options[55].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #00ffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #00ffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #00ffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb655563.sltNb554840.options[56].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb655563.sltNb554840.options[57].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">PG</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Customer 6</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">9999</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">CL</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>8</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">6</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #0000ff; TEXT-ALIGN: left"><A onclick="document.formFb655563.sltNb554840.options[61].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #0000ff; TEXT-ALIGN: left"><A onclick="document.formFb655563.sltNb554840.options[62].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ff9900; TEXT-ALIGN: left"><A onclick="document.formFb655563.sltNb554840.options[63].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ff9900; TEXT-ALIGN: left"><A onclick="document.formFb655563.sltNb554840.options[64].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: left"><A onclick="document.formFb655563.sltNb554840.options[65].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: left"><A onclick="document.formFb655563.sltNb554840.options[66].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #00ffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #00ffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #00ffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb655563.sltNb554840.options[67].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb655563.sltNb554840.options[68].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb655563.sltNb554840.options[69].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb655563.sltNb554840.options[70].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; VERTICAL-ALIGN: bottom; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb655563.sltNb554840.options[71].selected=true; document.formFb655563.txbFb064864.value = document.formFb655563.sltNb554840.value;" href="#javascript:void(0);"> 
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; VERTICAL-A

 

[brenner]

Once you select conditional formatting you can change the Condition 1 to "Formula Is" and set it equal to a formula for checking if there's a "c/o" is in column S. Does this help?

 

[Rockhopper3]

Don't know if this makes a difference but I am using Office 2007.
Here is the formula i tried using in conditonal formatting.

 =AND($S2="C/O",$U2="RM")

This worked as long as the information was on the same line in column B as it was in column S-V. Thoughts?

 

[brenner]

seems to work fine when i do it. did you select the entire gross sales range for RM before applying the conditional formatting?

 

[gardnertoo]

You have to set up an array formula in your conditional formatting, similar to the formula that is bringing your data in. Here's the formula for the conditional format of cell B3:

=IF(ISERROR(SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A3)),0,INDIRECT("S"&SMALL(IF($U$2:$U$203=$X$2,ROW($U$2:$U$203)),$A3))="c/o")

I copied the cell B3 formula and made the following changes.
1. Instead of the ISERROR returning a "" if true, it returns a 0
2. The INDIRECT looks to column S instead of column V
3. The ="c/o" after the indirect is added.

This formula works the same as the original formula in cell B3, but instead of returning the value from the cell it is INDIRECTed to look at, it tests that value to see if it does ="c/o". If so, the result of the formula is 1, if not (or if the ISERROR statement is true) the result is 0.

Note that as you copy formats over, you'll have to change the $X$2 to $X$3 for Pete, to $X$4 for Tony, etc.

 

[Rockhopper3]

worked perfectly. thanks to all for your help.