I'd like to highlight the max value in each column. Example :
A B C 1 50 12 60% 2 20 84 50% 3 38 20 15%
Here A1, B2, C1 will be highlighted. So I know how to do that for 1 column. I create a custom formula :
So if I do that, only the A1 cell will be highlighted. So how can I do that for the other column at the same time without duplicate conditionnal formatting on each column ?
I noticed that the max() function not working on percentage, it doesn't highlight my cell, do you know why ?