M
M
mUchenik2020-10-13 11:16:41
Google Sheets
mUchenik, 2020-10-13 11:16:41

How to highlight the smallest value in Google Spreadsheets?

How to implement in Google spreadsheets such a thing that in column A, from the set of data, the cells with the smallest value in green, and with the largest value in red are highlighted?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
dollar, 2020-10-13
@mUchenik

Conditional formatting.
Apply to range A:A
Continue with the formula.
Rule 1: =A1=MAX(A:A)
Rule 2: =A1=MIN(A:A)
PS Instead of A1, you need the address of the upper left cell of the range. In this case it is A1.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question