I want to highlight a row in a table based on the value in one of the columns.
Basically I've got a table of weeks, and I want the current week to be automatically highlighted. Using the TODAY() function and an IF statement I've created a column which is set to 1 if it is the current week, or 0 otherwise, like this:
<table border="0" cellpadding="0" cellspacing="0" width="338"><col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="mso-width-source:userset;mso-width-alt:2596;width:53pt" width="71"> <col style="width:48pt" span="3" width="64"> <tbody><tr style="height:15.75pt" height="21"> <td style="height:15.75pt;width:56pt" height="21" width="75">W/C</td> <td style="width:53pt" width="71">This Week</td> <td style="width:48pt" width="64">Data 1</td> <td style="width:48pt" width="64">Data 2</td> <td style="width:48pt" width="64">Data 3</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20" align="right">18/04/2011</td> <td align="right">0</td> <td align="right">4</td> <td align="right">5</td> <td align="right">6</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20" align="right">25/04/2011</td> <td align="right">1</td> <td align="right">1</td> <td align="right">5</td> <td align="right">6</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20" align="right">02/05/2011</td> <td align="right">0</td> <td align="right">78</td> <td align="right">4</td> <td align="right">20</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20" align="right">09/05/2011</td> <td align="right">0</td> <td align="right">100</td> <td align="right">132</td> <td align="right">78</td> </tr> </tbody></table>
I want to highlight the entire second row, based on the second column. Is this possible with conditional formatting, or some other means?
Basically I've got a table of weeks, and I want the current week to be automatically highlighted. Using the TODAY() function and an IF statement I've created a column which is set to 1 if it is the current week, or 0 otherwise, like this:
<table border="0" cellpadding="0" cellspacing="0" width="338"><col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="mso-width-source:userset;mso-width-alt:2596;width:53pt" width="71"> <col style="width:48pt" span="3" width="64"> <tbody><tr style="height:15.75pt" height="21"> <td style="height:15.75pt;width:56pt" height="21" width="75">W/C</td> <td style="width:53pt" width="71">This Week</td> <td style="width:48pt" width="64">Data 1</td> <td style="width:48pt" width="64">Data 2</td> <td style="width:48pt" width="64">Data 3</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20" align="right">18/04/2011</td> <td align="right">0</td> <td align="right">4</td> <td align="right">5</td> <td align="right">6</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20" align="right">25/04/2011</td> <td align="right">1</td> <td align="right">1</td> <td align="right">5</td> <td align="right">6</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20" align="right">02/05/2011</td> <td align="right">0</td> <td align="right">78</td> <td align="right">4</td> <td align="right">20</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20" align="right">09/05/2011</td> <td align="right">0</td> <td align="right">100</td> <td align="right">132</td> <td align="right">78</td> </tr> </tbody></table>
I want to highlight the entire second row, based on the second column. Is this possible with conditional formatting, or some other means?
