VBA to highlight sequential numbers in dynamic column

I have some spreadsheets we give to local service providers to list their employees and what services they are qualified to perform. However, sometimes when they fill in things like phone number, they use a company number and auto fill - and it fills as a series in error.

We run a macro on every spreadsheet that comes back in to verify all required information is present, but it doesn't catch when this happens.

The issue is that each spreadsheet is formatted different, so the phone number field isn't always in the same column - so I need a macro that will run based on the column header - not on the column letters.

I've tried and can't figure it out. Is this something that's even possible...to locate the phone number header and look down to highlight sequential numbers? The phone number is in a number format already, so I'm hoping it's something we can do so we don't have to keep checking manually.

Thanks!

I've attached a copy of the blank template. This is just one of them, the phone number is in Column I, but on others it's in different columns and I was hoping to avoid having to create a separate macro for each one. Thank you!

Directory Maintenance - v2.2.xlsx

Apologies...I've attached a populate sample, thank you

Sample Directory Maintenance - v2.2.xlsx

That's definitely an option if it would work best. This is just a sample, sometimes these listings have six to twelve thousand lines, and our spreadsheets have between 10 and 100 columns depending on the types of service providers we are sending them to...I assumed that conditional formatting to an entire spreadsheet when there could be that many rows on there would cause issues?

That worked! Thank you so much!!