Hi, Can you please help me with conditional formatting (highlight both cells) as with the below example to highlight the name "Mary" in the "NAME and "Qty" Columns on ranges A3:B7, C3:D7, E3:F7. I'm new here and its my first ever post,Thank You in advance.
<tbody>
</tbody>
<colgroup><col width="64" span="6" style="width:48pt"></colgroup><tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
SHIFT 1 | SHIFT 2 | SHIFT 3 | |||
NAME | QTY | NAME | QTY | NAME | QTY |
Mary | 25 | Bob | 54 | Mary | 50 |
Tony | 154 | Mary | 35 | Tony | 2 |
Denis | 200 | Bob | 321 | Mark | 147 |
Mary | 35 | Tony | 210 | Bob | 200 |
Mark | 320 | Mary | 100 | Denis | 54 |
<tbody>
</tbody>
<colgroup><col width="64" span="6" style="width:48pt"></colgroup><tbody>
</tbody>
<tbody>
</tbody>
|
<tbody>
</tbody>