highlight consecutive duplicates only if they repeat a specific number of times

[Jenni13]

Is there a way to count only when the data repeats a certain number of times in a row? For example, I need a formula to highlight cells only if the duplicate value occurs 30 or more times consecutively.
I have been using either "=COUNTIF(A1:A3,A2)>1" or "=OR(A2=A1,A2=A3)" in conditional formatting to highlight all consecutive duplicates. However, I have been unsuccessful in modifying these formulas to only highlight consecutive duplicates that occur 30 or more times in a row.

Thanks!

 

[jtakw]

Already answered here: http://www.mrexcel.com/forum/excel-...ght-duplicates-only-if-consecutive-cells.html

 

[Chrisdontm]

see above post...