Stephen_IV
Well-known Member
- Joined
- Mar 17, 2003
- Messages
- 1,177
- Office Version
- 365
- 2019
- Platform
- Windows
Good afternoon,
I have data based on 2 columns column B and E. What I would like to do is to highlight the group in yellow if the name and the DOB match. For instance AAAA and DDDD would be highlighted in this example.
Thanks in advance!!!!!
I have data based on 2 columns column B and E. What I would like to do is to highlight the group in yellow if the name and the DOB match. For instance AAAA and DDDD would be highlighted in this example.
Thanks in advance!!!!!
Rich (BB code):
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>
<table class="tableizer-table">
<thead><tr class="tableizer-firstrow"><th></th><th>NAME</th><th> </th><th> </th><th>DOB</th></tr></thead><tbody>
<tr><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td> </td><td>AAAA</td><td> </td><td> </td><td>7/6/2011</td></tr>
<tr><td> </td><td>AAAA</td><td> </td><td> </td><td>7/6/2011</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td> </td><td>BBBB</td><td> </td><td> </td><td>10/26/1987</td></tr>
<tr><td> </td><td>BBBB</td><td> </td><td> </td><td>10/18/1991</td></tr>
<tr><td> </td><td>BBBB</td><td> </td><td> </td><td>10/22/2000</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td> </td><td>CCCC</td><td> </td><td> </td><td>10/3/2002</td></tr>
<tr><td> </td><td>CCCC</td><td> </td><td> </td><td>8/15/2006</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td> </td><td>DDDD</td><td> </td><td> </td><td>8/7/2002</td></tr>
<tr><td> </td><td>DDDD</td><td> </td><td> </td><td>8/7/2002</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td> </td><td>EEEE</td><td> </td><td> </td><td>6/27/1994</td></tr>
<tr><td> </td><td>EEEE</td><td> </td><td> </td><td>4/15/1995</td></tr>
<tr><td> </td><td>EEEE</td><td> </td><td> </td><td>12/31/1989</td></tr>
</tbody></table>