D
D
dollar2022-01-26 16:04:32
Google Sheets
dollar, 2022-01-26 16:04:32

How to conditionally color in a column not the maximum number, but a certain number of numbers in the top?

There is a column, it can contain a lot of numbers.
We need to color the K largest ones. In the example below, K=2:
61f1477b89b86027641026.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
G
Germanjon, 2022-01-26
@dollar

Format - conditional formatting.
In the line "Value or formula" is inserted something like
=LARGE(B1:B7;2)
Here - B1:B7 - range
2 - value K

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question