Conditional Formatting

[Tobijp]

Is there a way to format a cell to only highlight data in a column once data is duplicated after the 7th time it is repeated? Thanks
e.g.
COLUMN A
1
2
3
3
3
3
3
3
3
4
4
4

 

[MarcelBeug]

Select all data in A2 and down, enter a new conditional formatting rule with formula =COUNTIF(A$2:A2,A2)>=7