Conditional formatting to ignore certain cell values in a row.

[Bolter LAC]

In column B each cell is populated from data in another worksheet (dates of events). There are also two specific events that are titled "REGION" and "STATE" that are also in the column. When data is entered into the cells of a row on a specific date a formula will attribute a "PB" (Personal Best) or "CR" (Club Record) if formula criteria is met. What I am after is for any cells in the row adjacent to "REGION" or "STATE" to ignore the "PB".

<TABLE style="WIDTH: 190pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=253 border=0><COLGROUP><COL style="WIDTH: 88pt; mso-width-source: userset; mso-width-alt: 4278" width=117><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1280" width=35><COL style="WIDTH: 28pt; mso-width-source: userset; mso-width-alt: 1353" width=37><TBODY><TR style="HEIGHT: 18.75pt" height=25><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 88pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" width=117 height=25>EVENT</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=64>70M</TD><TD class=xl66 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 26pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d8d8d8" width=35></TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 28pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d8d8d8" width=37></TD></TR><TR style="HEIGHT: 18.75pt" height=25><TD class=xl68 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" height=25>PB</TD><TD class=xl69 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">8.38</TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d8d8d8"></TD><TD class=xl71 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d8d8d8"></TD></TR><TR style="HEIGHT: 18pt" height=24><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 18pt; BACKGROUND-COLOR: transparent" height=24>CLUB REC</TD><TD class=xl83 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">8.38</TD><TD class=xl73 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d8d8d8"></TD><TD class=xl74 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d8d8d8"></TD></TR><TR style="HEIGHT: 18.75pt" height=25><TD class=xl84 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 18.75pt; BACKGROUND-COLOR: #d8d8d8" height=25>DATE</TD><TD class=xl75 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl76 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #d8d8d8"></TD><TD class=xl77 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #d8d8d8"></TD></TR><TR style="HEIGHT: 18pt" height=24><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18pt; BACKGROUND-COLOR: transparent" height=24>0/01/1900</TD><TD class=xl78 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl79 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl80 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 18pt" height=24><TD class=xl86 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18pt; BACKGROUND-COLOR: transparent" height=24>0/01/1900</TD><TD class=xl81 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl82 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl80 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 18pt" height=24><TD class=xl86 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18pt; BACKGROUND-COLOR: transparent" height=24>0/01/1900</TD><TD class=xl81 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl82 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl80 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 18.75pt" height=25><TD class=xl86 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" height=25>0/01/1900</TD><TD class=xl81 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl82 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl80 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 18.75pt" height=25><TD class=xl86 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" height=25>0/01/1900</TD><TD class=xl81 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl82 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl80 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 18pt" height=24><TD class=xl86 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18pt; BACKGROUND-COLOR: transparent" height=24>0/01/1900</TD><TD class=xl81 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">9.60</TD><TD class=xl82 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl80 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 18pt" height=24><TD class=xl86 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18pt; BACKGROUND-COLOR: transparent" height=24>0/01/1900</TD><TD class=xl81 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl82 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl80 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 18pt" height=24><TD class=xl86 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18pt; BACKGROUND-COLOR: transparent" height=24>0/01/1900</TD><TD class=xl81 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl82 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl80 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 18.75pt" height=25><TD class=xl86 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" height=25>0/01/1900</TD><TD class=xl81 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">9.58</TD><TD class=xl82 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">PB</TD><TD class=xl80 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 18.75pt" height=25><TD class=xl86 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" height=25>REGION</TD><TD class=xl81 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">9.57</TD><TD class=xl82 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">PB</TD><TD class=xl80 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 18pt" height=24><TD class=xl86 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18pt; BACKGROUND-COLOR: transparent" height=24>0/01/1900</TD><TD class=xl81 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl82 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl80 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 18pt" height=24><TD class=xl86 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18pt; BACKGROUND-COLOR: transparent" height=24>STATE</TD><TD class=xl81 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">8.38</TD><TD class=xl82 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">PB</TD><TD class=xl80 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">CR</TD></TR><TR style="HEIGHT: 18pt" height=24><TD class=xl86 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18pt; BACKGROUND-COLOR: transparent" height=24>0/01/1900</TD><TD class=xl81 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl82 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl80 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR></TBODY></TABLE>

Thanks Bolter

 

[jeffreybrown]

Not sure if this is what you after...

=IF(OR(A3={"Region","State"}),"","next if")

 

[Bolter LAC]

Sorry Jeff I think I am missing something with your formula, The sample I supplied (forgot how to post it properly - looking it up now) Col B has dates/region/state, Col C has data that is entered (times), Col D has formula for PB and Col E has formula for CR. I'm a bit rusty, wrote the program and now the club wants changes.

Thanks Bolter

 

[jeffreybrown]

What is the formula you use now? Could you post another shot using http://www.excel-jeanie-html.de/index.php?f=1

 

[Bolter LAC]

I have the add in Jeff, I just can't remember how to use it properly. Reading up on it now.

 

[Bolter LAC]

Hope this is better


16B10

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 11pt; FONT-FAMILY: Calibri,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 117px"><COL style="WIDTH: 64px"><COL style="WIDTH: 35px"><COL style="WIDTH: 37px"><COL style="WIDTH: 64px"><COL style="WIDTH: 35px"><COL style="WIDTH: 37px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD> </TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD></TR><TR style="HEIGHT: 23px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center">EVENT</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center">70M</TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center">100M</TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 23px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: #ff0000; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center">PB</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: #ff0000; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center">8.38</TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: #ff0000; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center">0.00</TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 22px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: #99cc00; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center">CLUB REC</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: #99cc00; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center">8.38</TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: #99cc00; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center">11.61</TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 23px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #d8d8d8; TEXT-ALIGN: center">DATE</TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8"> </TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8"> </TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 22px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center">0/01/1900</TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8"> </TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8"> </TD><TD style="FONT-SIZE: 14pt; COLOR: #008000; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8"> </TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8"> </TD><TD style="FONT-SIZE: 14pt; COLOR: #008000; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center"></TD></TR><TR style="HEIGHT: 22px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center">0/01/1900</TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center">9.60</TD><TD style="FONT-SIZE: 14pt; COLOR: #ff0000; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 14pt; COLOR: #008000; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8"> </TD><TD style="FONT-SIZE: 14pt; COLOR: #ff0000; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 14pt; COLOR: #008000; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center"></TD></TR><TR style="HEIGHT: 22px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center">0/01/1900</TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center">9.59</TD><TD style="FONT-SIZE: 14pt; COLOR: #ff0000; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center">PB</TD><TD style="FONT-SIZE: 14pt; COLOR: #008000; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8"> </TD><TD style="FONT-SIZE: 14pt; COLOR: #ff0000; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 14pt; COLOR: #008000; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center"></TD></TR><TR style="HEIGHT: 23px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center">REGION</TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center">9.58</TD><TD style="FONT-SIZE: 14pt; COLOR: #ff0000; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center">PB</TD><TD style="FONT-SIZE: 14pt; COLOR: #008000; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8"> </TD><TD style="FONT-SIZE: 14pt; COLOR: #ff0000; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 14pt; COLOR: #008000; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center"></TD></TR><TR style="HEIGHT: 23px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center">0/01/1900</TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8"> </TD><TD style="FONT-SIZE: 14pt; COLOR: #ff0000; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 14pt; COLOR: #008000; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8"> </TD><TD style="FONT-SIZE: 14pt; COLOR: #ff0000; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 14pt; COLOR: #008000; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center"></TD></TR><TR style="HEIGHT: 22px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center">STATE</TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center">8.38</TD><TD style="FONT-SIZE: 14pt; COLOR: #ff0000; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center">PB</TD><TD style="FONT-SIZE: 14pt; COLOR: #008000; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center">CR</TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8"> </TD><TD style="FONT-SIZE: 14pt; COLOR: #ff0000; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 14pt; COLOR: #008000; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center"></TD></TR><TR style="HEIGHT: 22px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">16</TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center">0/01/1900</TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8"> </TD><TD style="FONT-SIZE: 14pt; COLOR: #ff0000; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 14pt; COLOR: #008000; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8"> </TD><TD style="FONT-SIZE: 14pt; COLOR: #ff0000; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 14pt; COLOR: #008000; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ece9d8; TEXT-ALIGN: center"></TD></TR></TBODY></TABLE>
<TABLE style="FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #00ff00; BORDER-BOTTOM-COLOR: #00ff00; COLOR: #000000; BORDER-TOP-STYLE: groove; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-RIGHT-STYLE: groove; BORDER-LEFT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-RIGHT-COLOR: #00ff00; BORDER-BOTTOM-STYLE: groove"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-SIZE: 9pt; FONT-FAMILY: Arial" cellSpacing=0 cellPadding=2 border=1><TBODY><TR style="FONT-SIZE: 10pt; BACKGROUND-COLOR: #cacaca"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>C7</TD><TD>=MIN(C10:C30)</TD></TR><TR><TD>F7</TD><TD>=MIN(F10:F30)</TD></TR><TR><TD>C8</TD><TD>='Club Record'!D35</TD></TR><TR><TD>F8</TD><TD>='Club Record'!E35</TD></TR><TR><TD>B10</TD><TD>='Program Dates'!B4</TD></TR><TR><TD>E10</TD><TD>=IF(ISBLANK(C10)," ",IF(ISTEXT(C10)," ",IF(C10<=MIN(C$8:C8),"CR"," ")))</TD></TR><TR><TD>H10</TD><TD>=IF(ISBLANK(F10)," ",IF(ISTEXT(F10)," ",IF(F10<=MIN(F$8:F8),"CR"," ")))</TD></TR><TR><TD>B11</TD><TD>='Program Dates'!B5</TD></TR><TR><TD>D11</TD><TD>=IF(ISBLANK(C11)," ",IF(ISTEXT(C11)," ",IF(C11<(MIN(C$10:C10)),"PB"," ")))</TD></TR><TR><TD>E11</TD><TD>=IF(ISBLANK(C11)," ",IF(ISTEXT(C11)," ",IF(C11<=MIN(C$8:C10),"CR"," ")))</TD></TR><TR><TD>G11</TD><TD>=IF(ISBLANK(F11)," ",IF(ISTEXT(F11)," ",IF(F11<(MIN(F$10:F10)),"PB"," ")))</TD></TR><TR><TD>H11</TD><TD>=IF(ISBLANK(F11)," ",IF(ISTEXT(F11)," ",IF(F11<=MIN(F$8:F10),"CR"," ")))</TD></TR><TR><TD>B12</TD><TD>='Program Dates'!B6</TD></TR><TR><TD>D12</TD><TD>=IF(ISBLANK(C12)," ",IF(ISTEXT(C12)," ",IF(C12<(MIN(C$10:C11)),"PB"," ")))</TD></TR><TR><TD>E12</TD><TD>=IF(ISBLANK(C12)," ",IF(ISTEXT(C12)," ",IF(C12<=MIN(C$8:C11),"CR"," ")))</TD></TR><TR><TD>G12</TD><TD>=IF(ISBLANK(F12)," ",IF(ISTEXT(F12)," ",IF(F12<(MIN(F$10:F11)),"PB"," ")))</TD></TR><TR><TD>H12</TD><TD>=IF(ISBLANK(F12)," ",IF(ISTEXT(F12)," ",IF(F12<=MIN(F$8:F11),"CR"," ")))</TD></TR><TR><TD>B13</TD><TD>='Program Dates'!B7</TD></TR><TR><TD>D13</TD><TD>=IF(ISBLANK(C13)," ",IF(ISTEXT(C13)," ",IF(C13<(MIN(C$10:C12)),"PB"," ")))</TD></TR><TR><TD>E13</TD><TD>=IF(ISBLANK(C13)," ",IF(ISTEXT(C13)," ",IF(C13<=MIN(C$8:C12),"CR"," ")))</TD></TR><TR><TD>G13</TD><TD>=IF(ISBLANK(F13)," ",IF(ISTEXT(F13)," ",IF(F13<(MIN(F$10:F12)),"PB"," ")))</TD></TR><TR><TD>H13</TD><TD>=IF(ISBLANK(F13)," ",IF(ISTEXT(F13)," ",IF(F13<=MIN(F$8:F12),"CR"," ")))</TD></TR><TR><TD>B14</TD><TD>='Program Dates'!B8</TD></TR><TR><TD>D14</TD><TD>=IF(ISBLANK(C14)," ",IF(ISTEXT(C14)," ",IF(C14<(MIN(C$10:C13)),"PB"," ")))</TD></TR><TR><TD>E14</TD><TD>=IF(ISBLANK(C14)," ",IF(ISTEXT(C14)," ",IF(C14<=MIN(C$8:C13),"CR"," ")))</TD></TR><TR><TD>G14</TD><TD>=IF(ISBLANK(F14)," ",IF(ISTEXT(F14)," ",IF(F14<(MIN(F$10:F13)),"PB"," ")))</TD></TR><TR><TD>H14</TD><TD>=IF(ISBLANK(F14)," ",IF(ISTEXT(F14)," ",IF(F14<=MIN(F$8:F13),"CR"," ")))</TD></TR><TR><TD>B15</TD><TD>='Program Dates'!B9</TD></TR><TR><TD>D15</TD><TD>=IF(ISBLANK(C15)," ",IF(ISTEXT(C15)," ",IF(C15<(MIN(C$10:C14)),"PB"," ")))</TD></TR><TR><TD>E15</TD><TD>=IF(ISBLANK(C15)," ",IF(ISTEXT(C15)," ",IF(C15<=MIN(C$8:C14),"CR"," ")))</TD></TR><TR><TD>G15</TD><TD>=IF(ISBLANK(F15)," ",IF(ISTEXT(F15)," ",IF(F15<(MIN(F$10:F14)),"PB"," ")))</TD></TR><TR><TD>H15</TD><TD>=IF(ISBLANK(F15)," ",IF(ISTEXT(F15)," ",IF(F15<=MIN(F$8:F14),"CR"," ")))</TD></TR><TR><TD>B16</TD><TD>='Program Dates'!B10</TD></TR><TR><TD>D16</TD><TD>=IF(ISBLANK(C16)," ",IF(ISTEXT(C16)," ",IF(C16<(MIN(C$10:C15)),"PB"," ")))</TD></TR><TR><TD>E16</TD><TD>=IF(ISBLANK(C16)," ",IF(ISTEXT(C16)," ",IF(C16<=MIN(C$8:C15),"CR"," ")))</TD></TR><TR><TD>G16</TD><TD>=IF(ISBLANK(F16)," ",IF(ISTEXT(F16)," ",IF(F16<(MIN(F$10:F15)),"PB"," ")))</TD></TR><TR><TD>H16</TD><TD>=IF(ISBLANK(F16)," ",IF(ISTEXT(F16)," ",IF(F16<=MIN(F$8:F15),"CR"," ")))</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

 

[jeffreybrown]

Bolter,

With the given table below what are your expected results?

Sheet3

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 108px"><COL style="WIDTH: 63px"><COL style="WIDTH: 63px"><COL style="WIDTH: 63px"><COL style="WIDTH: 63px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD> </TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD></TR><TR style="HEIGHT: 24px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">EVENT</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">70M</TD><TD style="FONT-SIZE: 14pt"> </TD><TD style="FONT-SIZE: 14pt"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">100M</TD></TR><TR style="HEIGHT: 24px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: #ff0000; TEXT-ALIGN: center">PB</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: #ff0000; TEXT-ALIGN: center">8.38</TD><TD style="FONT-SIZE: 14pt"> </TD><TD style="FONT-SIZE: 14pt"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: #ff0000; TEXT-ALIGN: center">0</TD></TR><TR style="HEIGHT: 24px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: #99cc00; TEXT-ALIGN: center">CLUB REC</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: #99cc00; TEXT-ALIGN: center">8.38</TD><TD style="FONT-SIZE: 14pt"> </TD><TD style="FONT-SIZE: 14pt"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: #99cc00; TEXT-ALIGN: center">11.61</TD></TR><TR style="HEIGHT: 24px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">DATE</TD><TD style="FONT-SIZE: 14pt"> </TD><TD style="FONT-SIZE: 14pt"> </TD><TD style="FONT-SIZE: 14pt"> </TD><TD style="FONT-SIZE: 14pt"> </TD></TR><TR style="HEIGHT: 24px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="FONT-SIZE: 14pt; TEXT-ALIGN: left">0/01/1900</TD><TD style="FONT-SIZE: 14pt; TEXT-ALIGN: center">7.25</TD><TD style="FONT-SIZE: 14pt"> </TD><TD style="FONT-SIZE: 14pt; COLOR: #008000"> </TD><TD style="FONT-SIZE: 14pt"> </TD></TR><TR style="HEIGHT: 24px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="FONT-SIZE: 14pt; TEXT-ALIGN: left">0/01/1900</TD><TD style="FONT-SIZE: 14pt; TEXT-ALIGN: center">9.6</TD><TD style="FONT-SIZE: 14pt; COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 14pt; COLOR: #008000"> </TD><TD style="FONT-SIZE: 14pt"> </TD></TR><TR style="HEIGHT: 24px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="FONT-SIZE: 14pt; TEXT-ALIGN: left">0/01/1900</TD><TD style="FONT-SIZE: 14pt; TEXT-ALIGN: center">9.59</TD><TD style="FONT-SIZE: 14pt; COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 14pt; COLOR: #008000"> </TD><TD style="FONT-SIZE: 14pt"> </TD></TR><TR style="HEIGHT: 24px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD style="FONT-SIZE: 14pt; TEXT-ALIGN: left">REGION</TD><TD style="FONT-SIZE: 14pt; TEXT-ALIGN: center">9.58</TD><TD style="FONT-SIZE: 14pt; COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 14pt; COLOR: #008000"> </TD><TD style="FONT-SIZE: 14pt"> </TD></TR><TR style="HEIGHT: 24px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="FONT-SIZE: 14pt; TEXT-ALIGN: left">0/01/1900</TD><TD style="FONT-SIZE: 14pt; TEXT-ALIGN: center">9.2</TD><TD style="FONT-SIZE: 14pt; COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 14pt; COLOR: #008000"> </TD><TD style="FONT-SIZE: 14pt"> </TD></TR><TR style="HEIGHT: 24px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD style="FONT-SIZE: 14pt; TEXT-ALIGN: left">STATE</TD><TD style="FONT-SIZE: 14pt; TEXT-ALIGN: center">8.38</TD><TD style="FONT-SIZE: 14pt; COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 14pt; COLOR: #008000"> </TD><TD style="FONT-SIZE: 14pt"> </TD></TR><TR style="HEIGHT: 24px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD style="FONT-SIZE: 14pt; TEXT-ALIGN: left">0/01/1900</TD><TD style="FONT-SIZE: 14pt; TEXT-ALIGN: center">8.38</TD><TD style="FONT-SIZE: 14pt; COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 14pt; COLOR: #008000"> </TD><TD> </TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4