table display formulas vs VBA

[rjplante]

I have a table that looks like this:

<table border="0" cellpadding="0" cellspacing="0" width="283" height="203"><col style="width: 34pt;" width="45" span="3"> <col style="width: 62pt;" width="82"> <tbody><tr style="height: 15.75pt;" height="21"> <td class="xl63" style="height: 15.75pt; width: 34pt;" width="45" height="21">12</td> <td class="xl63" style="width: 34pt;" width="45">5</td> <td class="xl63" style="width: 34pt;" width="45">9</td> <td style="width: 62pt;" width="82"> </td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl63" style="height: 15.75pt;" height="21">4</td> <td class="xl63">3</td> <td class="xl63">13</td> <td>
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl63" style="height: 15.75pt;" height="21">15</td> <td class="xl63">11</td> <td class="xl63">8</td> <td>
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl63" style="height: 15.75pt;" height="21">20</td> <td class="xl63">24</td> <td class="xl63">17</td> <td>
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl63" style="height: 15.75pt;" height="21">9</td> <td class="xl63">8</td> <td class="xl63">4</td> <td>
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl64" style="height: 15.75pt;" height="21">18</td> <td class="xl64">9</td> <td class="xl64">14</td> <td>
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl63" style="height: 15.75pt;" height="21">78</td> <td class="xl63">60</td> <td class="xl63">65</td> <td>total</td> </tr> <tr style="height: 15.75pt;" height="21"> <td style="height: 15.75pt;" height="21">
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="height: 15.75pt;" height="21">70.2</td> <td class="xl65">54.0</td> <td class="xl65">58.5</td> <td>90% of total</td> </tr> </tbody></table>
I would like to have the lowest values in each column to be formatted w/ white text so that they are not displayed, but I want the total of the displayed numbers to be equal to or greater than the 90% value. Ideally It would be better to have the values removed, but then the calculated value of the sum and the 90% value would be affected. Is this possible to do this with formulas, or does it require VBA? If VBA is needed please supply the code.

Thanks,

Robert