'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 1:[1]

For each column do the following:

1) Select column or range (say it is A)
2) Select conditional formatting
3) Select in "Format rules" "custom formula is"
4) Enter the formula: =A1=MAX(A$1:A$6)

Here A1 - starting cell
A6 - ending cell

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Yaroslav Kornachevskyi