hi everyone

I need some help regarding the conditional formatting my excel is running slow. Here is the formula: =AND(COUNTIF($B:$B,$B14)=COUNTIF($B$14:$B14,$B14),$O14="P")

anyone have advise or another formula.

Thanks in advance!