Conditional Formatting Duplicate Value with 2 columns

hello i have an excel sheet where i would like to highlight duplicate value's, but not just one column, but rather to highlight duplicate value where 2 columns have exactly the same matching value,

the conditional formatting would operate only when 2 cells next to each other are duplicated else where, and it would highlight the 2 cells

You can do this with a combination of conditional formatting and a user defined function.

User defined function

Please Login or Register  to view this content.

Open the VBA editor by hitting Alt F11.
Insert a new module with Insert - Module
Paste in the above function
Go back to the sheet by hitting Alt F11.

Now set up the conditional formatting. I've assumed columns A and B are used and rows 1 to 7 are used.

Create a new rule and specify that it is determined with a formula.

Use the formula

=MatchAndDuplicate($A$1:$B$7,$A1:$B1)>1

and apply this to

=$A$1:$B$7


Remember to save the workbook as a macro enabled workbook .xlsm

An example is attached.