Link to home
Avatar of Andreas Hermle
Andreas HermleFlag for Germany

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
ASKER CERTIFIED SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Andreas Hermle

ASKER

Great job, Shums, this did the trick, thank you very much for it.

Regards, Andreas
Pleased to help :)