Search code examples
google-sheetsconditional-statementsgoogle-sheets-formulamaxconditional-formatting

How can I highlight the highest value in each row of a table?


In Google Sheets, I would like to highlight the max value in each row of a table.

I tried using conditional formatting, but without any success so far.


Solution

  • custom formula is:

    =(A1=MAX($A1:$D1))*(A1<>"")
    

    0


    for columns:

    =(A1=MAX(A$1:A))*(A1<>"")
    

    enter image description here