hello,
i have a very simple formula set up for conditional formatting however it's not working in 3 of my lines. I have double checked that the formula was correct it is... i have made sure the values are numbers not text and formatted the same way...
basically the formula is =I2=C2 it will then highlight the row gray as you see on the first line however the second line has the same formula with the corresponding letter to the row and it just doesn't work...any ideas?
<TABLE style="WIDTH: 378pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=506><COLGROUP><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3100" width=87><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2816" width=79><COL style="WIDTH: 61pt; mso-width-source: userset; mso-width-alt: 2901" width=82><COL style="WIDTH: 8pt; mso-width-source: userset; mso-width-alt: 369" width=10><COL style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1536" width=43><COL style="WIDTH: 39pt; mso-width-source: userset; mso-width-alt: 1848" width=52><COL style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1536" width=43><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 1962" width=55><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 1962" width=55><TBODY><TR style="HEIGHT: 25.8pt; mso-height-source: userset" height=34><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; WIDTH: 65pt; HEIGHT: 25.8pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl66 height=34 width=87>Original Total</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: white; WIDTH: 59pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl65 width=79>Actual Total</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: white; WIDTH: 61pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 1.5pt solid" class=xl79 width=82>Difference</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #7f7f7f; WIDTH: 8pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 1.5pt solid" class=xl74 width=10> </TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 32pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 1.5pt solid" class=xl67 width=43>Date</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 39pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 1.5pt solid" class=xl73 width=52>Amt</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 32pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 1.5pt solid" class=xl67 width=43>Date</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 41pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 1.5pt solid" class=xl69 width=55>Amt</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 41pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 1.5pt solid" class=xl72 width=55>Total add/ded</TD></TR><TR style="HEIGHT: 19.05pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND: #a5a5a5; HEIGHT: 19.05pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl63 height=25>$204.00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1.5pt solid; mso-pattern: black none" class=xl64>$192.16</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; FONT-FAMILY: Calibri; BACKGROUND: #a5a5a5; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 1.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl80>-11.84</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; FONT-FAMILY: Calibri; BACKGROUND: #a5a5a5; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl75> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl77> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl83>-11.84</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl68> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl70> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl83>-11.84</TD></TR><TR style="HEIGHT: 19.05pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; HEIGHT: 19.05pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=25>$204.00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1.5pt solid" class=xl64>$202.32</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid" class=xl81>-1.68</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #7f7f7f; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl75> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl78> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl83>-1.68</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl70> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl83>-1.68</TD></TR><TR style="HEIGHT: 19.05pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND: #a5a5a5; HEIGHT: 19.05pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl63 height=25>$255.00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1.5pt solid; mso-pattern: black none" class=xl64>$269.70</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; FONT-FAMILY: Calibri; BACKGROUND: #a5a5a5; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: windowtext 1.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 1.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl81>14.70</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; FONT-FAMILY: Calibri; BACKGROUND: #a5a5a5; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl75> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl78> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl83>14.70</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl68> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl70> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl83>14.70</TD></TR><TR style="HEIGHT: 19.05pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND: #a5a5a5; HEIGHT: 19.05pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl63 height=25>$255.00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1.5pt solid; mso-pattern: black none" class=xl64>$265.60</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; FONT-FAMILY: Calibri; BACKGROUND: #a5a5a5; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: windowtext 1.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 1.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl81>10.60</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; FONT-FAMILY: Calibri; BACKGROUND: #a5a5a5; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl75> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl78> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl83>10.60</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl68> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl70> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl83>10.60</TD></TR><TR style="HEIGHT: 19.05pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND: #a5a5a5; HEIGHT: 19.05pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl63 height=25>$255.00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1.5pt solid; mso-pattern: black none" class=xl64>$274.20</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; FONT-FAMILY: Calibri; BACKGROUND: #a5a5a5; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: windowtext 1.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 1.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl81>19.20</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; FONT-FAMILY: Calibri; BACKGROUND: #a5a5a5; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl75> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl78> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl83>19.20</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl68> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl70> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl83>19.20</TD></TR><TR style="HEIGHT: 19.05pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; HEIGHT: 19.05pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=25>$255.00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1.5pt solid" class=xl64>$250.10</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid" class=xl81>-4.90</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #7f7f7f; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl75> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl78> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl83>-4.90</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl70> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl83>-4.90</TD></TR><TR style="HEIGHT: 19.05pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND: #a5a5a5; HEIGHT: 19.05pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl63 height=25>$204.00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1.5pt solid; mso-pattern: black none" class=xl64>$200.72</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; FONT-FAMILY: Calibri; BACKGROUND: #a5a5a5; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: windowtext 1.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 1.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl81>-3.28</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; FONT-FAMILY: Calibri; BACKGROUND: #a5a5a5; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl75> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl78> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl83>-3.28</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl68> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl70> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl83>-3.28</TD></TR><TR style="HEIGHT: 19.05pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; HEIGHT: 19.05pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=25>$255.00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1.5pt solid" class=xl64>$252.70</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid" class=xl81>-2.30</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #7f7f7f; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl76> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl78> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl83>-2.30</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl70> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl83>-2.30</TD></TR></TBODY></TABLE>
i have a very simple formula set up for conditional formatting however it's not working in 3 of my lines. I have double checked that the formula was correct it is... i have made sure the values are numbers not text and formatted the same way...
basically the formula is =I2=C2 it will then highlight the row gray as you see on the first line however the second line has the same formula with the corresponding letter to the row and it just doesn't work...any ideas?
<TABLE style="WIDTH: 378pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=506><COLGROUP><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3100" width=87><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2816" width=79><COL style="WIDTH: 61pt; mso-width-source: userset; mso-width-alt: 2901" width=82><COL style="WIDTH: 8pt; mso-width-source: userset; mso-width-alt: 369" width=10><COL style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1536" width=43><COL style="WIDTH: 39pt; mso-width-source: userset; mso-width-alt: 1848" width=52><COL style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1536" width=43><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 1962" width=55><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 1962" width=55><TBODY><TR style="HEIGHT: 25.8pt; mso-height-source: userset" height=34><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; WIDTH: 65pt; HEIGHT: 25.8pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl66 height=34 width=87>Original Total</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: white; WIDTH: 59pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl65 width=79>Actual Total</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: white; WIDTH: 61pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 1.5pt solid" class=xl79 width=82>Difference</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #7f7f7f; WIDTH: 8pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 1.5pt solid" class=xl74 width=10> </TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 32pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 1.5pt solid" class=xl67 width=43>Date</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 39pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 1.5pt solid" class=xl73 width=52>Amt</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 32pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 1.5pt solid" class=xl67 width=43>Date</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 41pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 1.5pt solid" class=xl69 width=55>Amt</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 41pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 1.5pt solid" class=xl72 width=55>Total add/ded</TD></TR><TR style="HEIGHT: 19.05pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND: #a5a5a5; HEIGHT: 19.05pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl63 height=25>$204.00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1.5pt solid; mso-pattern: black none" class=xl64>$192.16</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; FONT-FAMILY: Calibri; BACKGROUND: #a5a5a5; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 1.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl80>-11.84</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; FONT-FAMILY: Calibri; BACKGROUND: #a5a5a5; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl75> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl77> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl83>-11.84</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl68> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl70> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl83>-11.84</TD></TR><TR style="HEIGHT: 19.05pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; HEIGHT: 19.05pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=25>$204.00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1.5pt solid" class=xl64>$202.32</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid" class=xl81>-1.68</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #7f7f7f; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl75> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl78> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl83>-1.68</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl70> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl83>-1.68</TD></TR><TR style="HEIGHT: 19.05pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND: #a5a5a5; HEIGHT: 19.05pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl63 height=25>$255.00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1.5pt solid; mso-pattern: black none" class=xl64>$269.70</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; FONT-FAMILY: Calibri; BACKGROUND: #a5a5a5; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: windowtext 1.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 1.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl81>14.70</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; FONT-FAMILY: Calibri; BACKGROUND: #a5a5a5; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl75> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl78> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl83>14.70</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl68> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl70> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl83>14.70</TD></TR><TR style="HEIGHT: 19.05pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND: #a5a5a5; HEIGHT: 19.05pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl63 height=25>$255.00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1.5pt solid; mso-pattern: black none" class=xl64>$265.60</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; FONT-FAMILY: Calibri; BACKGROUND: #a5a5a5; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: windowtext 1.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 1.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl81>10.60</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; FONT-FAMILY: Calibri; BACKGROUND: #a5a5a5; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl75> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl78> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl83>10.60</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl68> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl70> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl83>10.60</TD></TR><TR style="HEIGHT: 19.05pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND: #a5a5a5; HEIGHT: 19.05pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl63 height=25>$255.00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1.5pt solid; mso-pattern: black none" class=xl64>$274.20</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; FONT-FAMILY: Calibri; BACKGROUND: #a5a5a5; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: windowtext 1.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 1.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl81>19.20</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; FONT-FAMILY: Calibri; BACKGROUND: #a5a5a5; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl75> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl78> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl83>19.20</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl68> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl70> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl83>19.20</TD></TR><TR style="HEIGHT: 19.05pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; HEIGHT: 19.05pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=25>$255.00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1.5pt solid" class=xl64>$250.10</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid" class=xl81>-4.90</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #7f7f7f; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl75> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl78> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl83>-4.90</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl70> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl83>-4.90</TD></TR><TR style="HEIGHT: 19.05pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND: #a5a5a5; HEIGHT: 19.05pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl63 height=25>$204.00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1.5pt solid; mso-pattern: black none" class=xl64>$200.72</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; FONT-FAMILY: Calibri; BACKGROUND: #a5a5a5; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: windowtext 1.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 1.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl81>-3.28</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; FONT-FAMILY: Calibri; BACKGROUND: #a5a5a5; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl75> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl78> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl83>-3.28</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl68> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl70> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: #a5a5a5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-pattern: black none" class=xl83>-3.28</TD></TR><TR style="HEIGHT: 19.05pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; HEIGHT: 19.05pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=25>$255.00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1.5pt solid" class=xl64>$252.70</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid" class=xl81>-2.30</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #7f7f7f; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl76> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl78> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl83>-2.30</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl70> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl83>-2.30</TD></TR></TBODY></TABLE>