Hi, I am looking for a macro that will go through column B (States) and when the state changes from one to another I would like to highlight the range - basically color coding when the list changes from one state to the next. Please see the example attached...
Hi sriley5,
Run this while on the sheet you want the colour coding to be applied:
Regards,
Please Login or Register to view this content.
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Worked like a charm, quick and simple, I appreciate it!
You're welcome. Thanks for marking the thread as solved and for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks