Thank you so much for your quick response.

I found that Gary"s Student solution does the job so well - I have used
Barb's idea on the formula cells using conditional formatting to have the
result highlighted.

Thank you both again for your help, really appreciate it.

"Gary''s Student" <GarysStudent@discussions.microsoft.com> wrote in message
news:BC2610C3-6042-4A34-8BFD-FB8378D20F73@microsoft.com...
> Say you have used cols A & B for data and numbers, then in C6 insert:
>
> =IF((B6=B5)+(B6=B4)+(B6=B3)+(B6=B2)+(B6=B1)=5,1,"") amd copy down
>
> If there are 6 consecutive numbers in column B the function will return a
1,
> otherwise a blank.
> --
> Gary's Student
>
>
> "Patricia" wrote:
>
> > Good morning
> >
> > I have thousands of records, and need to be alerted when, consecutive
> > numbers (in a particular column) exceed 5. It has to be consecutive
numbers
> > (not sorted).
> >
> > eg
> > data 1
> > data 1
> > data 8
> > data 8
> > data 8
> > data 8
> > data 8
> > data 8
> >
> > In this case the number 8 exceeds 5.
> > Would really appreciate help on this, as at the moment it is really time
> > consuming.
> >
> > Thanking you in anticipation.
> >
> >
> >
> >