Forum Discussion
Solved
Conditional formatting on the row level
Hi, I have the following matrix and need to highlight the highest and lowest value per row (with a green/red arrow). Conditional formatting gives me the highest and lowest value of the whole matrix. ...
Hi lbendlin you'll find attached an excel file with an example of what I'm trying to do.
I need to highlight the highest and lowest value per row. I did a conditional formatting manually because there were only a few rows. If I aply conditional formatting to all the rows, it highlist only the highest and lowest value of the whole matrix.
Is there any way to solve this?
Many thanks!
Juan