Macro Which Highlights Rows That Contain Identical First Cells

[luu980]

Does anyone know of or can write a macro which will highlight the entire row of cells in which the values in A column are identical / repeats.

What I need is this, for example:

aaaa bbbb bbbb bbbb
aaaa dddd dddd dddd
aaaa cccc cccc cccc
1111 1111 1111 1111
mmmm xxxx xxxx xxxx
mmmm tttt tttt tttt
9999 9999 9999 9999
yyyy hhhh hhhh hhhh
yyyy iiii iiii iiii
0000 0000 0000 0000
ssss mnjk zzzz dddd
ssss fdfc ftgy edsw


Thus the resulting output would be:

The rows which contain 'aaaa' will be highlighted because the values in Column A are identical to each other.

The rows which contain 'mmmm' will be highlighted because the values in Column A are identical to each other.

The rows which contain 'yyyy' will be highlighted because the values in Column A are identical to each other.

The rows which contain 'ssss' will be highlighted because the values in Column A are identical to each other.

(Note, the highlight can all be one color, even though, for example: 'aaaa' and 'mmmm' are not identical values.


I don't know how to write macros at all and wasn't able to find one that does this. I am eternally grateful or any help that can be provided.