Solution to Highlight identical columns

[Joozh]

Hi,

I am looking for a manual as well as a VBA solution for this post. If you look at the attached image I need a solution to highlight a column (Col.2 in the case of my example) if the contents/value of Col.2 match Col. 1

Many advance thanks for your help.

 

[Special-K99]

Conditional Formatting

New Rule

=(UPPER(A1)=UPPER(B1))

format as required and use format painter to copy to other requiredcells

 

[VoG]

Conditional Formatting will work for this

Excel Workbook
	A	B
2	ABC	ABX
3	tytt	TYTT
4	tytt	tytt
Sheet8

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2	1. / Formula is =EXACT(A2,B2)	Abc

 

[Joozh]

Many thanks Special-K99 and VoG. Both solutions work nicely