max function in sheet

[PARK_JY]

Hi,

I want to change the background color of the cell with the largest OVER RATIO value in the table below.

so, I  wrote something like this

IF(COUNT("OVER COUNT")/Count("TOTAL COUNT")=(MAX(COUNT("OVER COUNT")/COUNT("TOTAL COUNT"))), 'RED')

BUT an error occurs.

Please let me know how to solve it.

[MayilVahanan]

Hi Park,

You can't use two aggregation function without aggr fn.

Try like below

IF(COUNT("OVER COUNT")/Count("TOTAL COUNT")=(MAX(Total Aggr(COUNT("OVER COUNT")/COUNT("TOTAL COUNT") ,urdimension))), 'RED')

or, store into variable and reuse where required.

[PARK_JY]

Hi MayilVahanan,

You have hepled me this time and before. Thank you.

I wrote the sentence you gave me.

No error occurred, but the background color did not change.

I'm sorry, but one more advice and what does 'urdimension' mean?

[MayilVahanan]

Hi

urdimension means, dimension used in the chart