Sure, just change the 1 to 3

=COUNTIF($A$1:$G$10000,A1)3

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Cameron" wrote:

That seems to have done the trick. Is there anyway to set a threshold? For
example - saying only highlight if the number of occurrences is greater then 3?