highlight duplicates in column

[thompson150]

Is there a way to highlight a cell value if it is the same as the value in the column next to it?

A B
1 55 58
2 67 66
3 56 80
4 47 47
5 44 66


I want to highlight cells A4 and B4, because they are the same value!

 

[VoG]

Try Conditional Formatting

Excel Workbook
	A	B
1	55	58
2	67	66
3	56	80
4	47	47
5	44	66
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Formula is =$A1=$B1	Abc
B1	1. / Formula is =$A1=$B1	Abc