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 ?

New contributor
John is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.

Use conditional formatting with the following custom formula: =B2=MAX(B$2:B$4). Change the cell names to suit your use case. B2 indicates the first cell in the selection and B$2:B$4 is first column in this example.

enter image description here


  • Perfect, thank you so much :) – John Nov 30 at 15:52

Your Answer

John is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.