Hi I'm not sure if its even possible to have a macro that I'm after but here we go.
In column E (last row as per col E), I have some order numbers as below:
before
Orders
104151034
104151042
200053133
200053133
200154048
200154048
200154049
200154046
200143380
200144746
200144746
200144746
200145035
200145035
200145035
200145060
200145060
200145060
200147188
200147188
200154047
200143013
200143013
200143013
As you can notice some of the order numbers are repeated. This is normal on my spreadsheet. If there are repeated numbers they normally are all in straight order and aren't scattered. Lets say order 200053133. As you can see one is on row 4 while next one follows on row 5. So normally they won't be scattered around like one is on row 4 and next time its on row 25, etc. This should be the case 100% of the time. Now what I would like to achieve is that there would be 2 different colours where VBA would change the cell interior color so they would swap after each order number to make things more visible. In a similar fashion as below:
after
Orders
104151034
104151042
200053133
200053133
200154048
200154048
200154049
200154046
200143380
200144746
200144746
200144746
200145035
200145035
200145035
200145060
200145060
200145060
200147188
200147188
200154047
200143013
200143013
200143013
If possible I would prefer to have VBA solution as I have some other ideas for conditional formating. But if its not possible with VBA but is an option with conditional formation, then I could live with it.
I have attached spreadsheet with sheets "before" and "after".
As always I'm very grateful of any help.
Cheers
Bookmarks