I need your excel help! – if I have three columns, I want to highlight the rows where the values in column 1 and 2 match, but are different in column 3. For instance:
<colgroup><col width="56" span="3" style="width:42pt"> </colgroup><tbody>
</tbody>
Here row 1 and 2 match in column 1 and 2, and also column 3 – everything ok
Row 3 and 4 also match in column 1 and 2, but column 3 does not – highlight
Row 4,5,6 - match in column 1 and 2, but column 3 is not the same for all 3 - highlight
If column 1&2 do not match, column 3 is irrelevant and no highlighting is necessary.
Do you know how to do this? That would safe me A LOT of pain and manual labor
A | 1 | xx |
A | 1 | xx |
A | 2 | xa |
A | 2 | da |
B | 3 | zz |
B | 3 | zz |
B | 3 | zy |
<colgroup><col width="56" span="3" style="width:42pt"> </colgroup><tbody>
</tbody>
Here row 1 and 2 match in column 1 and 2, and also column 3 – everything ok
Row 3 and 4 also match in column 1 and 2, but column 3 does not – highlight
Row 4,5,6 - match in column 1 and 2, but column 3 is not the same for all 3 - highlight
If column 1&2 do not match, column 3 is irrelevant and no highlighting is necessary.
Do you know how to do this? That would safe me A LOT of pain and manual labor