0
votes

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

2

2 Answers

1
votes

I think you want

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

enter image description here

1
votes

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

1: Select the hole 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))

If this is not what you are after then i misunderstood.

EDIT:

1: Select the hole range you want to include. 2: Right click and click conditional formatting 3: Choose higer then 4: Paste this in the formula bar

={G145,G146}

, could be ; depends on the country.