Conditional Formatting rules omitting quadruplicates

Copper Contributor

I'm tying to create a rule that will highlight cells that do not appear at least four times. example would be in one column:

cat

cat

cat

cat

dog

dog

dog

horse

all dog cells and horse cell would highlight because they did not appear 4 times. 

1 Reply

@nikib0987 Try below CF rule. See the attachment.

=COUNTIF($A$1:$A$8,A1)<4

 

Harun24HR_0-1661394718908.png