Conditional Formatting to find Top 3 Values in Multiple Columns

[Anonymity21]

Good afternoon everyone! I have a spreadsheet that I'm trying to conditionally format to display the top 3 values in each column (not including the value of 1). I believe I have to use an AND(LARGE()) type function, but I can't seem to get it to work. Any ideas?

 

[Caribeiro77]

If you don't have dups this might work:

Unknown

Row\Col	A​	B​	C​
1​	1​	2​	3​
2​	3​	4​	5​
3​	14​	6​	25​
4​	4​	5​	6​
5​	11​	1​	7​
6​	9​	10​	11​
7​	8​	9​	10​

Sheet: Sheet1

Select all the range and in the CF put the following:

=IF(A1<>1,OR(A1=LARGE(A$1:A$7,1),A1=LARGE(A$1:A$7,2),A1=LARGE(A$1:A$7,3)))

<tbody>
</tbody>

 

[Eric W]

To simplify Caribeiro's formula a little:

=AND(A1<>1,A1>=LARGE(A$1:A$7,3))

 

[Marcelo Branco]

What is the expected (desired) outcome with this data sample

	A​
1​	0,8​
2​	0,5​
3​	0,1​
4​	0,2​
5​	1​
6​	0,3​
7​	1​

<tbody>
</tbody>

Option 1

	A​
1​	0,8​
2​	0,5​
3​	0,1​
4​	0,2​
5​	1​
6​	0,3​
7​	1​

<tbody>
</tbody>

Option 2 (disregard the 1s to get the third Large)

	A​
1​	0,8​
2​	0,5​
3​	0,1​
4​	0,2​
5​	1​
6​	0,3​
7​	1​

<tbody>
</tbody>

Please, clarify.

M.