i need to find a formula to find the top three values in a column

Im looking for a formula to give me the top 3 values in a a data column. I would prefer to do this under conditional formatting, any suggestions? I know how to get the max value, it is the 2nd and third values I am lost upon.

Try the following:

Using LARGE function:

=LARGE(A$1:A$20,ROW($A1)) - this is considering the data range is from A1:A20
drag this down the cells.

OR,

Using conditional formatting:

• Select the Data Range
• Conditional Formatting
• New Rule
• Format only Top or Bottom Ranked Values
• Top - 3
• Color it based on your requirement

See the image below: