IF + MAX in Sheet

[PARK_JY]

Hi, 

I made a table based on script data.

The table I created is below.

LINE	Total Count	Over Count	Ratio
A_LINE
A_1	2505	253	10.1%
A_2	2663	255	9.6%
A_3	2659	544	20.5%
A_4	2646	549	20.7%
A_5	2643	562	21.3%
A_6	2620	429	16.4%
B_LINE
B_1	210	15	7.1%
B_2	208	23	11.1%
B_3	189	20	10.6%
B_4	191	54	28.3%
B_5	211	46	21.8%
B_6	184	21	11.4%

I  want to chage the background color to the maximum value of the ratio as in the table below.

Please let me know how to solve it.

Thank you.

[Lisa_P]

The coloring is controlled in the table properties panel, in the Data section, under the field you want to color.

Under the Ratio column, use if logic to apply yellow() color to max value.

eg IF(Ratio=Max(Ratio), yellow(), white())