Highlight changing numbers in column

Andreas Hermle
Andreas Hermle used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Managing Director/Excel VBA Developer
Distinguished Expert 2018
Commented:
You can use conditional formatting with below formula
=COUNTIF(A$1:A1,A1)=1

Open in new window

Please find attached for your reference.
Highlight_Changing_Numbers.xlsx
Andreas HermleTeam leader

Author

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

Regards, Andreas
ShumsManaging Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
Pleased to help :)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial