Hilight item numbers with a -04 suffix
Dear Experts:
I got a column with more than 16.000 item numbers. They all have the following make-up:
Example: 15-708-04-07, i.e. ##-###-##-##
I would like to highlight those (yellow cell fill) where the last two digits are -04.
The solution could be either conditional formatting, VBA or whatever.
Thank you very much in advance for your professional and kind help.
Regards, Andreas
I got a column with more than 16.000 item numbers. They all have the following make-up:
Example: 15-708-04-07, i.e. ##-###-##-##
I would like to highlight those (yellow cell fill) where the last two digits are -04.
The solution could be either conditional formatting, VBA or whatever.
Thank you very much in advance for your professional and kind help.
Regards, Andreas
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Dear all,
thank you very much for your professional help. All three work just fine (teylyn's and chwong's are similar).
Regards, Andreas
thank you very much for your professional help. All three work just fine (teylyn's and chwong's are similar).
Regards, Andreas
test.xls