Change Color for the Max Value on a table line

[jleraille]

In a Pivot Table how can I identified for each line, le maxvalue to change his color ?

I tried whith Rangemax but it's not ok - what's the best way ?

Thanks fot your help

Jacques

[jleraille · Accepted solution]

use HRANK to have result.
For example in color condition : if (HRank(sum(Valeurs)/count(Critère))= 1,LightGreen())

[anitamelbye]

Hi,

I have tried HRANK but it won't work, can someone please help me? I am doing something wrong, obviously!

I would have liked to have maxvalue in my prosent-columns marked with red text color.

I tried to write

if (HRank(SUM ( { $ < YEAR = { $(=MAX(YEAR))}, RNBILK = {4} >} -(RNBELØ)) /
 SUM ( { $ < YEAR = { $(=MAX(YEAR))}, RNBILK = {3} >} (RNBELØ)))= 1,RED()) 

..but it won't work..

I appreciate any suggestions 🙂

*newbee*

[anitamelbye]

No suggestions?

I would like to have maxvalue highlighted in red, what can I do?

Anita