Andreas Hermle
asked on
Highlight changing numbers in column
Dear Experts:
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.
Example:
O/243
O/243
O/243
S/374
S/374
S/374
G/192
G/192
K/334
L/419
S/342
F/224
F/224
T/343
T/343
etc.
Highlight_Changing_Numbers.xlsx
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.
Example:
O/243
O/243
O/243
S/374
S/374
S/374
G/192
G/192
K/334
L/419
S/342
F/224
F/224
T/343
T/343
etc.
Highlight_Changing_Numbers.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Pleased to help :)
ASKER
Regards, Andreas