'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 |
