Conditional Formatting

[pnlawton]

I am working on a report that will highlight progression of learner either red amber, of green based on values of week number on program and percent complete.

Where it gets interesting is say week is 48 should show 100 percent will be green but if lower that 90 show as red

I want to be colour to be selected from a range of that will differ dependent of the week number.


% Wk
<table x:str="" style="border-collapse: collapse; width: 144pt;" border="0" cellpadding="0" cellspacing="0" width="144"><col style="width: 48pt;" width="48" span="3"> <tbody><tr style="height: 12.75pt;" height="13"> <td style="height: 12.75pt; width: 48pt;" width="48" height="13">TL</td> <td style="width: 48pt;" x:num="" align="right" width="48">0</td> <td style="width: 48pt;" x:num="" align="right" width="48">4</td> </tr> <tr style="height: 12.75pt;" height="13"> <td style="height: 12.75pt;" height="13">RM3</td> <td x:num="" align="right">0</td> <td x:num="" align="right">12</td> </tr> <tr style="height: 12.75pt;" height="13"> <td style="height: 12.75pt;" height="13">RS2</td> <td x:num="" align="right">45</td> <td x:num="" align="right">12</td> </tr> <tr style="height: 12.75pt;" height="13"> <td style="height: 12.75pt;" height="13">TL</td> <td x:num="" align="right">25</td> <td x:num="" align="right">11</td> </tr> <tr style="height: 12.75pt;" height="13"> <td style="height: 12.75pt;" height="13">RS2</td> <td x:num="" align="right">0</td> <td x:num="" align="right">7</td> </tr> <tr style="height: 12.75pt;" height="13"> <td style="height: 12.75pt;" height="13">RS2</td> <td x:num="" align="right">3</td> <td x:num="" align="right">10</td> </tr> </tbody></table>