VBAProIWish
Well-known Member
- Joined
- Jul 6, 2009
- Messages
- 1,027
- Office Version
- 365
- Platform
- Windows
Hello All,
I am very new to Pivot Tables. They seem very powerful, but yet, I can't seem to get them to appear the way that I want them to.
Here's my issue...
Here is my data...
EXAMPLE 1
"Red" to "Wheat" are only in column A one time
"Light Red" to "Light Wheat" are in column A two times
"Dark Red" to "Dark Wheat" are in column A three times
So, I did a Pivot Table, and it looks like this now...
EXAMPLE 2
What I WANT it to look like is this....
EXAMPLE 3
I would like..
> All the "Color Total" rows to be deleted out (there must be some feature within the Pivot Table for this?
> All these rows out
<TABLE style="WIDTH: 176pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=236 x:str><COLGROUP><COL style="WIDTH: 95pt; mso-width-source: userset; mso-width-alt: 4522" width=127><COL style="WIDTH: 55pt; mso-width-source: userset; mso-width-alt: 2616" width=74><COL style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1251" width=35><TBODY><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 95pt; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18 width=127>(blank)</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl29 width=74>(blank)</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 26pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl27 width=35></TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>(blank) Total</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl28></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl27></TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl25 height=18>Grand Total</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl30></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl26 align=right x:num>48</TD></TR></TBODY></TABLE>
> Sorted by Amount, Descending
> And, if possible, the formatting that I have intact, if too difficult, I will still be VERY happy with just the fields and positions the way that I have them.
Note that I copied and paste specialed / values only a few columns to the right to get the data. At this point, I don't care if the data isn't "updatable" from the original source.
I'd like to do this via a Sub if possible.
Whew! Thanks!
I am very new to Pivot Tables. They seem very powerful, but yet, I can't seem to get them to appear the way that I want them to.
Here's my issue...
Here is my data...
EXAMPLE 1
Code:
<TABLE style="WIDTH: 222pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=296 x:str><COLGROUP><COL style="WIDTH: 169pt; mso-width-source: userset; mso-width-alt: 7992" width=225><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2531" width=71><TBODY><TR style="HEIGHT: 22.8pt; mso-height-source: userset" height=30><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: yellow; WIDTH: 169pt; HEIGHT: 22.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl24 height=30 width=225>[B][FONT=Calibri]COLOR[/FONT][/B]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: yellow; WIDTH: 53pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl25 width=71>[B][FONT=Calibri]Amount[/FONT][/B]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Red[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Blue[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Green[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Brown[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Orange[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Yellow[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Pink[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18 x:str="Wheat ">[SIZE=2][FONT=Calibri]Wheat [/FONT][/SIZE]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Light Red[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Light Blue[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Light Green[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Light Brown[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Light Orange[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Light Yellow[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Light Pink[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Light Wheat[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Dark Red[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Dark Blue[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Dark Green[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Dark Brown[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Dark Orange[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Dark Yellow[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Dark Pink[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Dark Wheat[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Light Red[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Light Blue[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Light Green[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Light Brown[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Light Orange[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Light Yellow[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Light Pink[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Light Wheat[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Dark Red[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Dark Blue[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Dark Green[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Dark Brown[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Dark Orange[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Dark Yellow[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Dark Pink[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Dark Wheat[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Dark Red[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Dark Blue[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Dark Green[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Dark Brown[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Dark Orange[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Dark Yellow[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Dark Pink[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18>[FONT=Calibri][SIZE=2]Dark Wheat[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl26 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD></TR></TBODY></TABLE>
"Red" to "Wheat" are only in column A one time
"Light Red" to "Light Wheat" are in column A two times
"Dark Red" to "Dark Wheat" are in column A three times
So, I did a Pivot Table, and it looks like this now...
EXAMPLE 2
Code:
<TABLE style="WIDTH: 176pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=236 x:str><COLGROUP><COL style="WIDTH: 95pt; mso-width-source: userset; mso-width-alt: 4522" width=127><COL style="WIDTH: 55pt; mso-width-source: userset; mso-width-alt: 2616" width=74><COL style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1251" width=35><TBODY><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 95pt; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18 width=127>[FONT=Calibri][SIZE=2]Count of COLOR[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; WIDTH: 55pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl28 width=74></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 26pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 width=35></TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]COLOR[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl29>[FONT=Calibri][SIZE=2]Amount[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25>[FONT=Calibri][SIZE=2]Total[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Blue[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl29 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]1[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Blue Total[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl28></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]1[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Brown[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl29 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]1[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Brown Total[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl28></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]1[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Dark Blue[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl29 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]3[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Dark Blue Total[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl28></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]3[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Dark Brown[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl29 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]3[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Dark Brown Total[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl28></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]3[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Dark Green[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl29 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]3[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Dark Green Total[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl28></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]3[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Dark Orange[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl29 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]3[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Dark Orange Total[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl28></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]3[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Dark Pink[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl29 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]3[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Dark Pink Total[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl28></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]3[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Dark Red[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl29 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]3[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Dark Red Total[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl28></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]3[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Dark Wheat[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl29 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]3[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Dark Wheat Total[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl28></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]3[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Dark Yellow[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl29 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]3[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Dark Yellow Total[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl28></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]3[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Green[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl29 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]1[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Green Total[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl28></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]1[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Light Blue[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl29 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]2[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Light Blue Total[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl28></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]2[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Light Brown[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl29 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]2[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Light Brown Total[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl28></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]2[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Light Green[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl29 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]2[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Light Green Total[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl28></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]2[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Light Orange[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl29 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]2[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Light Orange Total[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl28></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]2[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Light Pink[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl29 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]2[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Light Pink Total[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl28></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]2[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Light Red[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl29 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]2[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Light Red Total[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl28></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]2[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Light Wheat[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl29 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]2[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Light Wheat Total[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl28></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]2[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Light Yellow[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl29 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]2[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Light Yellow Total[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl28></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]2[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Orange[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl29 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]1[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Orange Total[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl28></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]1[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Pink[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl29 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]1[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Pink Total[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl28></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]1[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Red[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl29 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]1[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Red Total[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl28></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]1[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18 x:str="Wheat ">[SIZE=2][FONT=Calibri]Wheat [/FONT][/SIZE]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl29 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]1[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Wheat Total[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl28></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]1[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Yellow[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl29 align=right x:num="100">[FONT=Calibri][SIZE=2]$100.00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]1[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2]Yellow Total[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl28></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 align=right x:num>[FONT=Calibri][SIZE=2]1[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2](blank)[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl29>[FONT=Calibri][SIZE=2](blank)[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25></TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>[FONT=Calibri][SIZE=2](blank) Total[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl28></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25></TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl26 height=18>[FONT=Calibri][SIZE=2]Grand Total[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl30></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl27 align=right x:num>[FONT=Calibri][SIZE=2]48[/SIZE][/FONT]</TD></TR></TBODY></TABLE>
What I WANT it to look like is this....
EXAMPLE 3
Code:
<TABLE style="WIDTH: 142pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=190 x:str><COLGROUP><COL style="WIDTH: 58pt; mso-width-source: userset; mso-width-alt: 2759" width=78><COL style="WIDTH: 36pt; mso-width-source: userset; mso-width-alt: 1706" width=48><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 43.2pt; mso-height-source: userset" height=58><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: yellow; WIDTH: 58pt; HEIGHT: 43.2pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl24 height=58 width=78>COLOR</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; WIDTH: 36pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl25 width=48>Total</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; WIDTH: 48pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 1.5pt solid" class=xl35 width=64>Amount</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl26 height=19>Dark Blue</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl27 align=right x:num>3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid" class=xl28 align=right x:num="300">$300.00</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=18>Dark Brown</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30 align=right x:num>3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid" class=xl31 align=right x:num="300">$300.00</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=18>Dark Green</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30 align=right x:num>3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid" class=xl31 align=right x:num="300">$300.00</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=18>Dark Orange</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30 align=right x:num>3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid" class=xl31 align=right x:num="300">$300.00</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=18>Dark Pink</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30 align=right x:num>3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid" class=xl31 align=right x:num="300">$300.00</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=18>Dark Red</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30 align=right x:num>3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid" class=xl31 align=right x:num="300">$300.00</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=18>Dark Wheat</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30 align=right x:num>3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid" class=xl31 align=right x:num="300">$300.00</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=18>Dark Yellow</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30 align=right x:num>3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid" class=xl31 align=right x:num="300">$300.00</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=18>Light Blue</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30 align=right x:num>2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid" class=xl31 align=right x:num="200">$200.00</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=18>Light Brown</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30 align=right x:num>2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid" class=xl31 align=right x:num="200">$200.00</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=18>Light Green</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30 align=right x:num>2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid" class=xl31 align=right x:num="200">$200.00</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=18>Light Orange</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30 align=right x:num>2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid" class=xl31 align=right x:num="200">$200.00</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=18>Light Pink</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30 align=right x:num>2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid" class=xl31 align=right x:num="200">$200.00</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=18>Light Red</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30 align=right x:num>2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid" class=xl31 align=right x:num="200">$200.00</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=18>Light Wheat</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30 align=right x:num>2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid" class=xl31 align=right x:num="200">$200.00</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=18>Light Yellow</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30 align=right x:num>2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid" class=xl31 align=right x:num="200">$200.00</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=18>Blue</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30 align=right x:num>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid" class=xl31 align=right x:num="100">$100.00</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=18>Brown</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30 align=right x:num>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid" class=xl31 align=right x:num="100">$100.00</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=18>Green</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30 align=right x:num>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid" class=xl31 align=right x:num="100">$100.00</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=18>Orange</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30 align=right x:num>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid" class=xl31 align=right x:num="100">$100.00</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=18>Pink</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30 align=right x:num>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid" class=xl31 align=right x:num="100">$100.00</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=18>Red</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30 align=right x:num>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid" class=xl31 align=right x:num="100">$100.00</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=18 x:str="Wheat ">Wheat </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30 align=right x:num>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid" class=xl31 align=right x:num="100">$100.00</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl32 height=19>Yellow</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl33 align=right x:num>1</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid" class=xl34 align=right x:num="100">$100.00</TD></TR></TBODY></TABLE>
I would like..
> All the "Color Total" rows to be deleted out (there must be some feature within the Pivot Table for this?
> All these rows out
<TABLE style="WIDTH: 176pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=236 x:str><COLGROUP><COL style="WIDTH: 95pt; mso-width-source: userset; mso-width-alt: 4522" width=127><COL style="WIDTH: 55pt; mso-width-source: userset; mso-width-alt: 2616" width=74><COL style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1251" width=35><TBODY><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 95pt; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18 width=127>(blank)</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl29 width=74>(blank)</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 26pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl27 width=35></TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl24 height=18>(blank) Total</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl28></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl27></TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl25 height=18>Grand Total</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #e0dfe3" class=xl30></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl26 align=right x:num>48</TD></TR></TBODY></TABLE>
> Sorted by Amount, Descending
> And, if possible, the formatting that I have intact, if too difficult, I will still be VERY happy with just the fields and positions the way that I have them.
Note that I copied and paste specialed / values only a few columns to the right to get the data. At this point, I don't care if the data isn't "updatable" from the original source.
I'd like to do this via a Sub if possible.
Whew! Thanks!