finding top 3 countings and using conditional formatting

[mwvirk]

hello

i am trying to find the top 3 counts and then applying the condition formatting using the below formulas:

=OR(L2=MAX(L$2:L$31),L2=LARGE(L$2:L$31,1))
=OR(L2=MAX(L$2:L$31),L2=LARGE(L$2:L$31,2))
=OR(L2=MAX(L$2:L$31),L2=LARGE(L$2:L$31,3))

when searching and applying for the 1st & 2nd, it's working but when applying the 3rd formula, it's not changing the format in fact applying the 3rd formula for the 1st condition.

Election 2022.xlsx
	L
2	1,000
3	500
4	2
5	9,000
6	4
7	2,700
8	30,000
9	32,000
10	2,700
11	10
12	11
13	12
14	13
15	14
16	15
17	16
18	17
19	18
20	19
21	20
22	21
23	22
24	23
25	24
26	25
27	26
28	27,000
29	28
30	9
31	10
Election 2022 (MNA)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
L2:L31	Expression	=OR(L2=MAX(L$2:L$31),L2=LARGE(L$2:L$31,3))	text	NO
L2:M31	Expression	=OR(L2=MAX(L$2:L$31),L2=LARGE(L$2:L$31,1))	text	NO
L2:M31	Expression	=OR(L2=MAX(L$2:L$31),L2=LARGE(L$2:L$31,2))	text	NO

 

[6StringJazzer]

There is no reason to use the reference to MAX. With your original rules, they will all be TRUE for the largest number.

=L2=LARGE(L$2:L$31,1)
=L2=LARGE(L$2:L$31,2)
=L2=LARGE(L$2:L$31,3)

 

[AlphaFrog]

Cell	Condition	Cell Format	Stop If True
Cells with Conditional Formatting
L2:M31	Expression	=$L2=MAX($L$2:$L$31)	number	NO
L2:M31	Expression	=$L2=LARGE($L$2:$L$31,2)	number	NO
L2:M31	Expression	=$L2=LARGE($L$2:$L$31,3)	number	NO

 

[mwvirk]

thank you