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