Identifying a Range & altering formatting

[Battychick]

Hi.

I'm stuck with an exceptionally large file that needs "prettying up" before sending for work, and I'm spending hours doing the following manually.

Lets say I have a column B, and each row has a weekend identifier:
B1 Weekend 1
B2 Weekend 2
B3 Weekend 3
B4 Weekend 5
B5 Weekend 9
B6 Weekend 10
B7 Weekend 11
B8 Weekend 3
B9 Weekend 4

So I need to identify the 3 consecutive weekends, and format it to red bold as shown. The previous column has an identifier (so B1 - B7 is one group, and B8 onwards another)

BTW, this is just one fo the tabs on the sheet. The other tabs contain various other data sets. So I need something that can be run over specific tabs only.

Obviously, the sheet I'm on has 30,000 rows (and that's just one of the 84 reports)

If anyone can help me do this an easier way, I'd be most grateful.

 

[Battychick]

Thanks. I'll give this a go today and let you know.