I have column A with a list of numbers, and I am trying to highlight the top 3 highest value/s. However, conditional formatting is not working properly if there are duplicate values.
Highest value/s – Color Blue
2nd Highest value/s – Color Yellow
3rd Highest value/s – Color Green
Other Values...