Forum Discussion
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
If you follow Mr. Hans Vogelaar's steps it should work without any problem...it works for me.
Attached is an additional example file.
Conditionally Formatting Data: Examples and Guidelines
...for do-it-yourself 🙂
- still it's not working.
- 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)" - If I may recommend, include this file (without sensitive data) so that we can understand why it doesn't work for your file.
