# SolvedConditional Format Custom Formula Google Sheets

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

#### Squashman

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

#### etaf

Wayne
Moderator
Select range AG:AG
then use the formula
=\$AG1=max(AG:AG)

also
\$AG1=min(AG:AG)

#### Squashman

Select range AG:AG
then use the formula
=\$AG1=max(AG:AG)

also
\$AG1=min(AG:AG)
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)``

#### etaf

Wayne
Moderator
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)

#### Squashman

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.

#### etaf

Wayne
Moderator
you are welcome

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

As Seen On

### Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

over 807,865 other people just like you!