I need a condition format to highlight the consecutive range of numbers in Excel

Would you please help?

I need a formula in excel that highlight the consecutive numbers.

I have this column with thousand of numbers. Basically, I want to see the min and max in ranges.

for example.



457

458

459

460

470

471

473

477

566

569

570

571

572

573

Thank you.

Lyly

Thank you but that formula only highlighted a series of 2 numbers. I ranges that contains 10 to 100 numbers