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:catcatcatcatdogdogdoghorseall dog cells and horse cell would highlight because they did not appear 4 times.

nikib0987 Try below CF rule. See the attachment.=COUNTIF($A$1:$A$8,A1)<4

Forum Discussion

Copper Contributor

Aug 25, 2022

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

dog

horse

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