# Solved Conditional Format Custom Formula Google Sheets

Discussion in 'Business Applications' started by Squashman, Apr 2, 2019.

Not open for further replies.

Joined:
Apr 4, 2003
Messages:
19,786
I am using conditional formatting with a custom formula in Google Sheets to fill color the minimum and maximum values in a column.

The minimum works just fine:
Code:
`=\$AG:\$AG=min(AG:AG)`
But if I change min to max nothing in the column gets highlighted.
Code:
`=\$AG:\$AG=max(AG:AG)`
The range is set to AG2:AG25

2. ### etafModerator

Joined:
Oct 2, 2003
Messages:
65,207
First Name:
Wayne
Select range AG:AG
then use the formula
=\$AG1=max(AG:AG)

also
\$AG1=min(AG:AG)

Joined:
Apr 4, 2003
Messages:
19,786
I can't set the range to AG:AG because the last row in all the columns have a sum total. So currently AG26 has the total.

This seems to work though.
Code:
`=\$AG2>=large(\$AG\$2:\$AG,2)`

4. ### etafModerator

Joined:
Oct 2, 2003
Messages:
65,207
First Name:
Wayne
you dont need to select the full range , i was just following your original post
But the formula needs to be the same row as the start of the range

so if you choose A4:A100 say , then the formula starts with row 4

therefore if you are using range A2 to A25 to conditional format
Select AG2:AG25
conditional formatting formula

=AG2=max(AG\$2:AG\$25)
=AG2=min(AG\$2:AG\$25)

Joined:
Apr 4, 2003
Messages:
19,786
That works. Now I understand. I have never been good with spread sheets. I hated Quattro Pro back in the day but my wife built a whole NASCAR fantasy league in it for me 20 years ago.

6. ### etafModerator

Joined:
Oct 2, 2003
Messages:
65,207
First Name:
Wayne
you are welcome

As Seen On