Pivot tables for conditional formatting

stan_ · Jan 29, 2010

****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 12">****** name="Originator" content="Microsoft Word 12"><link rel="File-List" href="file:///C:%5CUsers%5Csthomas%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="themeData" href="file:///C:%5CUsers%5Csthomas%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CUsers%5Csthomas%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"><style> <!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:1; mso-generic-font-family:roman; mso-font-format

ther; mso-font-pitch:variable; mso-font-signature:0 0 0 0 0 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin-top:6.0pt; margin-right:0in; margin-bottom:3.0pt; margin-left:0in; text-indent:.3in; mso-pagination:widow-orphan; font-size:12.0pt; mso-bidi-font-size:11.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} span.highlight {mso-style-name:highlight; mso-style-unhide:no;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-size:12.0pt; mso-ansi-font-size:12.0pt; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} .MsoPapDefault {mso-style-type:export-only; margin-top:6.0pt; margin-right:0in; margin-bottom:3.0pt; margin-left:0in; text-indent:.3in;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style> stanleythms@yahoo.com [FONT=&quot]Hi - I am doing a little microbiology project with lot of numbers and I thought using pivot table to analyze it would be really good. I need to check 3 different columns to see if the value is true, and if it is, then find out how many times this occurs. These are test results of 3 types of bacteria tested on various surfaces. I want to see the date, surface that each bacterium meets the condition (or values are true). I would also like to filter it many ways like by year, month, etc...[/FONT]Is there a way that I can make use of a pivot table and display the number of times the values are true.
Please see the attached spreadsheet (Excel 2007) with sample data. On the sample pivot tab, I have displayed how I would like to see the pivot table. I appreciate any help. Thanks in advance.
<table style="border-collapse: collapse; width: 851px; height: 502px;" border="0" cellpadding="0" cellspacing="0"><col style="width: 54pt;" width="72" span="3"> <col style="width: 59pt;" width="79"> <col style="width: 73pt;" width="97"> <col style="width: 54pt;" width="72"> <col style="width: 43pt;" width="57"> <col style="width: 72pt;" width="96"> <col style="width: 56pt;" width="75"> <col style="width: 71pt;" width="94"> <col style="width: 54pt;" width="72"> <tbody><tr style="height: 37.5pt;" height="50"> <td class="xl66" style="height: 37.5pt; width: 54pt;" width="72" height="50">Week #</td> <td class="xl66" style="border-left: medium none; width: 54pt;" width="72">Month</td> <td class="xl66" style="border-left: medium none; width: 54pt;" width="72">Year</td> <td class="xl67" style="border-left: medium none; width: 59pt;" width="79">Date of Sample</td> <td class="xl67" style="border-left: medium none; width: 73pt;" width="97">Surface</td> <td class="xl67" style="border-left: medium none; width: 54pt;" width="72">Bacteria A</td> <td class="xl67" style="border-left: medium none; width: 43pt;" width="57">Bac A result</td> <td class="xl67" style="border-left: medium none; width: 72pt;" width="96">Bacteria B</td> <td class="xl67" style="border-left: medium none; width: 56pt;" width="75">Bac B result</td> <td class="xl67" style="border-left: medium none; width: 71pt;" width="94">Bacteria C</td> <td class="xl67" style="border-left: medium none; width: 54pt;" width="72">Bac C result</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="border-top: medium none; height: 15.75pt;" height="21">2</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">2009</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">1/4/2009</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Surface 1</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">121</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">2</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="border-top: medium none; height: 15.75pt;" height="21">6</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">2</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">2009</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">2/5/2009</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Surface 2</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">78</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">17</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">7</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="border-top: medium none; height: 15.75pt;" height="21">27</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">7</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">2009</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">7/4/2009</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Surface 3</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">89</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">6</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="border-top: medium none; height: 15.75pt;" height="21">5</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">2009</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">1/26/2009</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Surface 4</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">13</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">1</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="border-top: medium none; height: 15.75pt;" height="21">45</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">11</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">2009</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">11/4/2009</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Surface 5</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">78</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">11</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">1</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="border-top: medium none; height: 15.75pt;" height="21">49</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">12</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">2009</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">12/4/2009</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Surface 6</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">113</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">10</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">1</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="border-top: medium none; height: 15.75pt;" height="21">45</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">11</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">2009</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">11/5/2009</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Surface 1</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">79</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">3</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="border-top: medium none; height: 15.75pt;" height="21">6</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">2</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">2009</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">2/4/2009</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Surface 8</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">23</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">14</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">1</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="border-top: medium none; height: 15.75pt;" height="21">11</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">3</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">2009</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">3/14/2009</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Surface 9</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">14</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">1</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="border-top: medium none; height: 15.75pt;" height="21">36</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">9</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">2009</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">9/4/2009</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Surface 10</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">34</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">12</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">1</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="border-top: medium none; height: 15.75pt;" height="21">32</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">8</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">2009</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">8/4/2009</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Surface 11</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">99</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">5</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="border-top: medium none; height: 15.75pt;" height="21">16</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">4</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">2009</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">4/12/2009</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Surface 2</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">9</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">8</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="border-top: medium none; height: 15.75pt;" height="21">23</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">6</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">2009</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">6/4/2009</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Surface 15</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">124</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="border-top: medium none; height: 15.75pt;" height="21">23</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">6</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">2009</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">6/6/2009</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Surface 14</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">50</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">36</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">4</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="border-top: medium none; height: 15.75pt;" height="21">37</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">9</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">2009</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">9/11/2009</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Surface 15</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">81</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">9</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="border-top: medium none; height: 15.75pt;" height="21">32</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">8</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">2009</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">8/4/2009</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Surface 6</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">5</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">9</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="border-top: medium none; height: 15.75pt;" height="21">31</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">8</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">2009</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">8/1/2009</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Surface 17</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">51</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">9</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">12</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">1</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="border-top: medium none; height: 15.75pt;" height="21">41</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">10</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">2009</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">10/10/2009</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Surface 18</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">193</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">50</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">12</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">1</td> </tr> </tbody></table><table style="border-collapse: collapse; width: 867px; height: 425px;" border="0" cellpadding="0" cellspacing="0"><tbody> <tr style="height: 15.75pt;" height="21"> <td style="height: 15.75pt;" align="right" height="21">
</td> <td align="right">
</td><td align="right">
</td><td class="xl65" align="right">
</td> <td>
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td style="height: 15.75pt;" align="right" height="21">
</td> <td align="right">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> <td>
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td style="height: 15.75pt;" align="right" height="21">
</td> <td align="right">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> <td>
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td style="height: 15.75pt;" align="right" height="21">
</td> <td align="right">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> <td>
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td style="height: 15.75pt;" align="right" height="21">
</td> <td align="right">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> <td>
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td style="height: 15.75pt;" align="right" height="21">
</td> <td align="right">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> <td>
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td style="height: 15.75pt;" align="right" height="21">
</td> <td align="right">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> <td>
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td style="height: 15.75pt;" align="right" height="21">
</td> <td align="right">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> <td>
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td style="height: 15.75pt;" align="right" height="21">
</td> <td align="right">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> <td>
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td style="height: 15.75pt;" align="right" height="21">
</td> <td align="right">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> <td>
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td style="height: 15.75pt;" align="right" height="21">
</td> <td align="right">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> <td>
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td style="height: 15.75pt;" align="right" height="21">
</td> <td align="right">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> <td>
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td style="height: 15.75pt;" align="right" height="21">
</td> <td align="right">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> <td>
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td style="height: 15.75pt;" align="right" height="21">
</td> <td align="right">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> <td>
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td style="height: 15.75pt;" align="right" height="21">
</td> <td align="right">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> <td>
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td style="height: 15.75pt;" align="right" height="21">
</td> <td align="right">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> <td>
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td style="height: 15.75pt;" align="right" height="21">
</td> <td align="right">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> <td>
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td style="height: 15.75pt;" align="right" height="21">
</td> <td align="right">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> <td>
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> <td align="right">
</td> <td class="xl66">
</td> </tr> </tbody></table>Sample pivot
<table style="border-collapse: collapse; width: 599px; height: 250px;" border="0" cellpadding="0" cellspacing="0"><col style="width: 87pt;" width="116"> <col style="width: 115pt;" width="153" span="3"> <tbody><tr style="height: 15.75pt;" height="21"> <td class="xl65" style="height: 15.75pt; width: 87pt;" width="116" height="21">
</td> <td class="xl65" style="border-left: medium none; width: 115pt;" width="153">Values</td> <td class="xl65" style="border-left: medium none; width: 115pt;" width="153">
</td> <td class="xl65" style="border-left: medium none; width: 115pt;" width="153">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Row Labels</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">Count of Bac A result</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">Count of Bac B result</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">Count of Bac C result</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl66" style="border-top: medium none; height: 15.75pt;" align="right" height="21">1/4/2009</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">1</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl66" style="border-top: medium none; height: 15.75pt;" align="right" height="21">2/5/2009</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">1</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl66" style="border-top: medium none; height: 15.75pt;" align="right" height="21">12/4/2009</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">1</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">1</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl66" style="border-top: medium none; height: 15.75pt;" align="right" height="21">1/26/2009</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">1</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl66" style="border-top: medium none; height: 15.75pt;" align="right" height="21">11/4/2009</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">1</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">and so on…</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Grand Total</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">2</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">1</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">3</td> </tr> </tbody></table>

Pivot tables for conditional formatting

stan_

New Member

Excel Facts

Similar threads

Forum statistics

Share this page

Pivot tables for conditional formatting

stan_

New Member

Excel Facts

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock