Thinking about my last post.

In my job I regularly have to work with spreadsheets of 80,000 plus rows and I thought people might find the following of use.

What if the groups you want to format have irregular numbers of rows? Have a look at the attached. The main formula for the formatting is the same as beforehand. It's all in Column B.

In this example we're highlighting each change in reference number. Start by entering 1 in cell B2 and then use the formula in B3 the rest of the way down. This also acts as a handy indicator of how many unique reference numbers there are.

Apply the formula as before. Job done!!

Good luck

Tony

Attached Files

Conformat2.xlsx (51.5 KB, 16 views)