Can I find the two closest adjacent data points in Excel?

Hey all,

I have multiple pages of data and I need to find the two adjacent rows on each page that have the smallest difference in them.

E.g.
0.41581
0.46611
0.39498
0.58341
0.57520
0.42977
0.54351
0.64867
0.50810
0.49935
0.62768
0.60185
0.54170
0.61906
0.46601
0.58252
0.51897
0.54903
0.55894
0.56617
0.56323
0.51466
0.27893
0.66893
0.66734
0.56658
0.51281
0.62324
0.66549
0.76005
0.74205
0.62957
0.66535
0.62426
0.57915
0.50971

I need to find the two closest adjacent numbers in this list (i.e. the two adjacent rows with the smallest difference). I have to do it 96 times so I am hoping and wishing that there is a formula for it. Graphing it all out and eyeballing the two closest points is getting tiresome fast ;-S

Cheers

How about this.
There is a calculation in C1 and Conditional formatting in A column.

Are you likely to have two differences which are both minimum?

Pete

No, not likely. But it could happen I suppose, but it would be a huge coincidence.

Nice, that looks like it should work. Thanks heaps!
Are you able to explain it really briefly? I'm not quite a complete beginner at excel but I am pretty amateur..