I have a list like this:
D6915
D6915-07
D6915 - 05b
D6915 - 05a
D6915 - 05
D6914 - 07
D6915 - 03
except that the list contains 50,000 rows. I want to highlight every cell below the one that ends in -07, so in this case, I would highlight the one that ends in 05b and 03.
Someone please please help me with this. I am giving myself carpal tunnel doing this by hand
Bookmarks