# Conditional formatting per row - highest value

**URL:** <https://community.amazonquick.com/t/conditional-formatting-per-row-highest-value/6205>\
**Category:** Q&A\
**Tags:** formatting, quick-sight\
**Created:** [September 22, 2022, 9:57am UTC](https://community.amazonquick.com/t/conditional-formatting-per-row-highest-value/6205 "2022-09-22T09:57:49Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Patrizia\_Buompastore](https://avatars.discourse-cdn.com/v4/letter/p/bc8723/32.png) [@Patrizia\_Buompastore](https://community.amazonquick.com/u/Patrizia_Buompastore)\
**Post date:** [September 22, 2022, 9:57am UTC](https://community.amazonquick.com/t/conditional-formatting-per-row-highest-value/6205/1 "2022-09-22T09:57:49Z")

</div>

Is there a way to use conditional formatting to show me which value of the column is the highest?

ROWS: list of brands  
COLUMNS: list of countries  
VALUE: revenue

---

<div class="post-metadata">

**Author:** ![n\_vetri](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/n_vetri/32/2924_2.png) [@n\_vetri](https://community.amazonquick.com/u/n_vetri)\
**Post date:** [September 22, 2022, 2:01pm UTC](https://community.amazonquick.com/t/conditional-formatting-per-row-highest-value/6205/2 "2022-09-22T14:01:37Z")

</div>

Hi @Patrizia_Buompastore  
I assume that its for the Pivot Table.

**First Option:**  
Out of the box solution: Please use gradient fill type in conditional formatting.

**Second Option**  
If you want to highlight only the top and not the other values,  
You can use a calculated field to compute the rank for the Value by countries.  
`rank([sum(Sales) DESC], [Industry])`

You can then use it in the conditional formatting to highlight only the top value. Please see the image below. Is this the expected outcome? Here the product with highest sales in each industry is highlighted.

If you want to highlight the Industry with highest sales in each product just change the rank as below:

`rank([sum(Sales) DESC], [Product])`

 ![highlight top rank-pivot](https://d1wl4jav5dp96l.cloudfront.net/original/2X/0/0eebffda1e0ac9f24cce0a3f37751bc0ceab2877.png)

Regards  
Vetri

---

<div class="post-metadata">

**Author:** ![Patrizia\_Buompastore](https://avatars.discourse-cdn.com/v4/letter/p/bc8723/32.png) [@Patrizia\_Buompastore](https://community.amazonquick.com/u/Patrizia_Buompastore)\
**Post date:** [September 22, 2022, 3:02pm UTC](https://community.amazonquick.com/t/conditional-formatting-per-row-highest-value/6205/3 "2022-09-22T15:02:13Z")

</div>

> [@n\_vetri](#):
>
> type in conditional formattin

Hi Vetri,

I followed you instructions, however only 1 single value is highlighted for me. I h ave the exact same case as you, with countries (columns) and names(rows)

and I used this formula rank by country = **rank([sum(revenue) DESC], [‘country’])**

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/c/c1a47cec852dcb0216ab19e7999ee27b0c7c4608.png)