Highlight equal row text

[Manolocs]

Hello, How to Highlight two consecutive equal text cells in a table ? I have to find, identify and manually delete multiple rows of an extensive table with 5 columns, the search for consecutive identical rows is needed by the column "A" only, the other columns maybe not equal. I tried already with conditional formatting but while I am deleting the entire row, the conditional missed a lot of identical cells.
Any idea how to make it easier?
Thanks in advance.

 

[Manolocs]

There are spaces in many places, it is not constant, it is copy/past from somewhere else, so the format sometimes is different.

 

[Manolocs]

Please take a look in this example....
https://dl.dropboxusercontent.com/u/14313867/some questions.xlsx
Thanks....

 

[Fishboy]

Please take a look in this example....
https://dl.dropboxusercontent.com/u/14313867/some questions.xlsx
Thanks....

Hmm, OK the short answer is "Yes, that can probably still be done".

The long answer is "No, that is unfortunately beyond my current capability and I wouldn't even know how or where to start".

Sorry man, but I am not good enough to handle that yet I'm afraid

 

[Manolocs]

Come on you help a lot, thank you for your time.....

 

[Fishboy]

Come on you help a lot, thank you for your time.....

You are most welcome. Any help I have been able to provide so far has been my pleasure, but the latest query has me stumped I am afraid.