Conditional formatting on the row level

[juan_123]

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. Need to apply it to row level.

The table consist of product - brand (Fosfato diamónico - Bunge) and on the columns is the price for different locations (Buenos Aires, Córdoba, etc).

Many thanks!
Juan

[juan_123]

Many thanks ! 

Will try it

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[juan_123]

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

https://docs.google.com/spreadsheets/d/1K-AB5Ci5xXcwzrQA4O2laSXrTAvEC5Kv/edit?usp=sharing&ouid=10075...

[lbendlin · Accepted solution]