Forum Discussion

Ioannisd's avatar
Ioannisd
Copper Contributor
Jan 12, 2023

Highlight higher value of different cells

hi,   i want to highlight  higher value(cell) in every row from different - seperate collums for example  i have B2 , D2 , F2 cells with values
excel
Excel for web
Ioannisd's avatar
Ioannisd
Copper Contributor
Jan 13, 2023
still it's not working.
XXplore's avatar
XXplore
Brass Contributor
Jan 13, 2023
It works and I think you need check your formular:
Use "=B2=MAX($B2,$D2,$F2)"
Not "=B2=MAX($B$2,$D$2,$F$2)"

Resources