To all,

I have a list of numbers in column A on sheet1. i.e.


1
2
3
4
5
6
7
8
9
10
2
3
4
5
6


etc....

I am trying to write a macro that will identify 8 consecutive cells
that are increasing in values, or 8 consecutive cells that are
decreasing in value, and then highlight these 8 cells. So for example
in the example list it would highlight 1, 2, 3, 4, 5,6 7, 8, and
2,3,4,5,6,7,8,9, and 3,4,5,6,7,8,9,10 etc.

ANy help would be much appreciated,

Kind Regards

Joseph Crabtree