Example, this is the data in Excel:
1 2
2 2
3 4
3 4
3 3
2 2
2 2
1 2
The rows which have consecutive duplicate columnpair values (in bold font) should be highlighted:
1 2
2 2
3 4
3 4
3 3
2 2
2 2
1 2
Example, this is the data in Excel: 1 2 The rows which have consecutive duplicate columnpair values (in bold font) should be highlighted: 1 2 


This can be done by just using conditional formatting: Highlight the entire range. Select Conditional Formatting and choose to use a formula. Type the formula: Explanation: The formula assumes is basically applied to every cell, but you write it assuming you're in the first cell in the range and assume that excel will copy it to the rest. That's why the columns are absolute references ($'s before the B's and C's), so the columns are constant even as it's 'copied' to the rest of the cells. 


If a third column can be used instead you can easily achieve this with a formula
Paste this in col 3 row 2 and copy till the bottom p.s. syntax might be slightly off on excel, this was tested on open office 


Try this You will also need conditional formatting. 

