Highlight common char in column A

[p30tec]

Hi
How can I highlight common char (or difference) in column A(case-insensitive)?

for example in this sample

	A
1	abcdefghiq
2	abcdezghiw
3	abcxyzghiq
4	abcxyughiexyz

if you compare all strings in column A , just abc and ghi is common part, So I want this result

	A
1	abcdefghiq
2	abcdezghiw
3	abcxyzghiq
4	abcxyughiexyz

I want to compare first char of column A if all is equal highlight first char , next compare second char next ...

[mrice]

Try this - select the range of cells first

Please Login or Register  to view this content.

Open up the VBA editor by hitting ALT F11

Insert a new module by hitting Insert - Module

Paste the macro into the empty sheet

Hit ALT F11 to get back to the worksheet.

Run the macro by going to tools-macro in Excel 2003 or the view ribbon in Excel 2007/2010.

[mrice]

Accidentally submitted twice

[p30tec]

Thank you mrice
I do this and when I press Run this Error shown

Run-time Error '9':
Subscript out of range

I press Debug and in VBA this line highlighted

[p30tec]

Solved
Thanks Martin for your GREAT help

[mrice]

Suspect that you had a blank cell in your selected range.