I got a row of alphanumerical strings in Column A. Whenever the alphanumerical string changes to another the first occurrence is to be highlighted in some way. The best would be: cell fill red and cell font white.
Help is much appreciated. Thank you very much in advance. Regards, Andreas
I have attached a sample file for your convenience.