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.
custom formula is:
=(A1=MAX($A1:$D1))*(A1<>"")
for columns:
=(A1=MAX(A$1:A))*(A1<>"")