conditional formatting

[rcirone]

<TABLE class=MsoNormalTable style="BORDER-COLLAPSE: collapse; mso-table-layout-alt: fixed; mso-padding-alt: 0in 1.5pt 0in 1.5pt" cellSpacing=0 cellPadding=0 border=0><TBODY><TR style="HEIGHT: 12.35pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes"><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; BACKGROUND: #ccffff; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 97.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.35pt; mso-border-right-alt: solid white .75pt; mso-shading: white; mso-pattern: solid #CCFFFF" vAlign=top width=130>CC<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: white 1pt solid; PADDING-LEFT: 1.5pt; BACKGROUND: #ccffff; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; mso-shading: white; mso-pattern: solid #CCFFFF; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt" vAlign=top width=67>

100%<o></o>​

</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: white 1pt solid; PADDING-LEFT: 1.5pt; BACKGROUND: #ccffff; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.55pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; mso-shading: white; mso-pattern: solid #CCFFFF; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt" vAlign=top width=67>

67%<o></o>​

</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: white 1pt solid; PADDING-LEFT: 1.5pt; BACKGROUND: #ccffff; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; mso-shading: white; mso-pattern: solid #CCFFFF; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt" vAlign=top width=67>

100%<o></o>​

</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: white 1pt solid; PADDING-LEFT: 1.5pt; BACKGROUND: #ccffff; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.55pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; mso-shading: white; mso-pattern: solid #CCFFFF; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt" vAlign=top width=67>

100%<o></o>​

</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: white 1pt solid; PADDING-LEFT: 1.5pt; BACKGROUND: #ccffff; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; mso-shading: white; mso-pattern: solid #CCFFFF; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt" vAlign=top width=67>

0%<o></o>​

</TD></TR><TR style="HEIGHT: 12.35pt; mso-yfti-irow: 1"><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; BACKGROUND: #ccffff; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 97.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.35pt; mso-border-right-alt: solid white .75pt; mso-shading: white; mso-pattern: solid #CCFFFF" vAlign=top width=130>

<o> </o>​

</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; BACKGROUND: #ccffff; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; mso-shading: white; mso-pattern: solid #CCFFFF; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt; mso-border-top-alt: solid white .75pt" vAlign=top width=67>

2<o></o>​

</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; BACKGROUND: #ccffff; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.55pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; mso-shading: white; mso-pattern: solid #CCFFFF; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt; mso-border-top-alt: solid white .75pt" vAlign=top width=67>

3<o></o>​

</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; BACKGROUND: #ccffff; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; mso-shading: white; mso-pattern: solid #CCFFFF; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt; mso-border-top-alt: solid white .75pt" vAlign=top width=67>

3<o></o>​

</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; BACKGROUND: #ccffff; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.55pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; mso-shading: white; mso-pattern: solid #CCFFFF; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt; mso-border-top-alt: solid white .75pt" vAlign=top width=67>

3<o></o>​

</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; BACKGROUND: #ccffff; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; mso-shading: white; mso-pattern: solid #CCFFFF; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt; mso-border-top-alt: solid white .75pt" vAlign=top width=67>

1<o></o>​

</TD></TR><TR style="HEIGHT: 12.35pt; mso-yfti-irow: 2"><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 97.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.35pt; BACKGROUND-COLOR: transparent; mso-border-right-alt: solid white .75pt" vAlign=top width=130>NALM<o></o>
</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt; mso-border-top-alt: solid white .75pt" vAlign=top width=67><o> </o>
</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.55pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt; mso-border-top-alt: solid white .75pt" vAlign=top width=67><o> </o>
</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt; mso-border-top-alt: solid white .75pt" vAlign=top width=67><o> </o>
</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.55pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt; mso-border-top-alt: solid white .75pt" vAlign=top width=67><o> </o>
</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt; mso-border-top-alt: solid white .75pt" vAlign=top width=67><o> </o>
</TD></TR><TR style="HEIGHT: 12.35pt; mso-yfti-irow: 3"><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 97.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.35pt; BACKGROUND-COLOR: transparent; mso-border-right-alt: solid white .75pt" vAlign=top width=130>

<o> </o>​

</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt; mso-border-top-alt: solid white .75pt" vAlign=top width=67>

0<o></o>​

</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.55pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt; mso-border-top-alt: solid white .75pt" vAlign=top width=67>

0<o></o>​

</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt; mso-border-top-alt: solid white .75pt" vAlign=top width=67>

0<o></o>​

</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.55pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt; mso-border-top-alt: solid white .75pt" vAlign=top width=67>

0<o></o>​

</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt; mso-border-top-alt: solid white .75pt" vAlign=top width=67>

0<o></o>​

</TD></TR><TR style="HEIGHT: 12.35pt; mso-yfti-irow: 4"><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; BACKGROUND: #ccffff; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 97.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.35pt; mso-border-right-alt: solid white .75pt; mso-shading: white; mso-pattern: solid #CCFFFF" vAlign=top width=130>6-10K<o></o>
</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; BACKGROUND: #ccffff; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; mso-shading: white; mso-pattern: solid #CCFFFF; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt; mso-border-top-alt: solid white .75pt" vAlign=top width=67>

0%<o></o>​

</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; BACKGROUND: #ccffff; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.55pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; mso-shading: white; mso-pattern: solid #CCFFFF; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt; mso-border-top-alt: solid white .75pt" vAlign=top width=67><o> </o>
</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; BACKGROUND: #ccffff; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; mso-shading: white; mso-pattern: solid #CCFFFF; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt; mso-border-top-alt: solid white .75pt" vAlign=top width=67><o> </o>
</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; BACKGROUND: #ccffff; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.55pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; mso-shading: white; mso-pattern: solid #CCFFFF; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt; mso-border-top-alt: solid white .75pt" vAlign=top width=67><o> </o>
</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; BACKGROUND: #ccffff; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; mso-shading: white; mso-pattern: solid #CCFFFF; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt; mso-border-top-alt: solid white .75pt" vAlign=top width=67>

100%<o></o>​

</TD></TR><TR style="HEIGHT: 12.35pt; mso-yfti-irow: 5"><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; BACKGROUND: #ccffff; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 97.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.35pt; mso-border-right-alt: solid white .75pt; mso-shading: white; mso-pattern: solid #CCFFFF" vAlign=top width=130>

<o> </o>​

</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; BACKGROUND: #ccffff; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; mso-shading: white; mso-pattern: solid #CCFFFF; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt; mso-border-top-alt: solid white .75pt" vAlign=top width=67>

1<o></o>​

</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; BACKGROUND: #ccffff; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.55pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; mso-shading: white; mso-pattern: solid #CCFFFF; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt; mso-border-top-alt: solid white .75pt" vAlign=top width=67>

0<o></o>​

</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; BACKGROUND: #ccffff; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; mso-shading: white; mso-pattern: solid #CCFFFF; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt; mso-border-top-alt: solid white .75pt" vAlign=top width=67>

0<o></o>​

</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; BACKGROUND: #ccffff; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.55pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; mso-shading: white; mso-pattern: solid #CCFFFF; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt; mso-border-top-alt: solid white .75pt" vAlign=top width=67>

0<o></o>​

</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; BACKGROUND: #ccffff; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; mso-shading: white; mso-pattern: solid #CCFFFF; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt; mso-border-top-alt: solid white .75pt" vAlign=top width=67>

1<o></o>​

</TD></TR><TR style="HEIGHT: 12.35pt; mso-yfti-irow: 6; mso-yfti-lastrow: yes"><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 97.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.35pt; BACKGROUND-COLOR: transparent; mso-border-right-alt: solid white .75pt" vAlign=top width=130>LM<o></o>
</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt; mso-border-top-alt: solid white .75pt" vAlign=top width=67><o> </o>
</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.55pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt; mso-border-top-alt: solid white .75pt" vAlign=top width=67><o> </o>
</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt; mso-border-top-alt: solid white .75pt" vAlign=top width=67><o> </o>
</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.55pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt; mso-border-top-alt: solid white .75pt" vAlign=top width=67><o> </o>
</TD><TD style="BORDER-RIGHT: white 1pt solid; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 1.5pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 50.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: white 1pt solid; HEIGHT: 12.35pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: solid white .75pt; mso-border-alt: solid white .75pt; mso-border-top-alt: solid white .75pt" vAlign=top width=67>

100%<o></o>​

</TD></TR></TBODY></TABLE>
<o> </o>
this is what I am looking for conditional formatting from what is put in column A
so I need the hole row of A1,A2 and A5,A6 to be highlighted

 

[Gerald Higgins]

WHY are rows 1, 2, 5 and 6 highlighted ?

Is it just a case of highlighting alternate pairs of lines, or is there some more complicated logic behind it ?

 

[rcirone]

yes I am trying to do alternate pairs of lines I have 5140 lines to look at please help

 

[c_m]

Select the range first and then try this formula in conditional formatting:
=MOD(ROW(),2)
Select your format and click ok

 

[lenze]

From Chip Pearson
http://www.cpearson.com/Excel/banding.aspx

=MOD(ROW()-Rw,N*2)+1<=N

Where Rw is the 1st row of your data and N = number of rows in each band
lenze