CODEWITHSUNDEEP
google-sheets
user14205287
user14205287

Reputation:

Google Sheets dynamic conditional formatting

Is it possible to do dynamic conditional formatting in GS.

This is my formula in "Conditional formatting:

=$G145:$G146=MAX($G145:$G146)

I want to be able to drag the conditional formatting across the rows. Basically I want to highlight which cell in in Range G145-G146 is higher. But then drag it across the Column (Higher of Column H, Higher of column I, Higher of column J and so on).

enter image description here

Picture two:

enter image description here

Upvotes: 0

Views: 2210

Answers (2)

RemcoE33
RemcoE33

Reputation: 1620

Yes it is. But you don't 'drag' it.

  1. Select the whole range you want to include.

  2. Right click and click conditional formatting

  3. Choose custom formula

  4. Adjust the formula below to the same range you selected

    =max(arrayformula($G$5:$Z))

EDIT:

  1. Select the whole range you want to include.

  2. Right click and click conditional formatting

  3. Choose higher then

  4. Paste this in the formula bar

    ={G145,G146}

, could be ; depends on the country.

Upvotes: 1

Tom Sharpe
Tom Sharpe

Reputation: 34420

I think you want

=G145=max(G$145:G$146)

enter image description here

Upvotes: 1

Related Questions