How to colour the diagonal values in Pivot table?

[#1]

Hi,

I have the Pivot chart with data which is in attached. I would need to colour the diagonal values which is in Pivot table. Please can anyone suggest me is it possible?

Thanks.

[#2]

Please see attached.

[eduardo_sommer · Accepted solution]

Try using this in the background color property of the expression:

     if (RowNo() = ColumnNo(), LightRed())

[#4]

Thanks. How can I change for all diagonal values. Please suggest me.

EDIT:  I tried using the below it is changing the colour. But I need exact change in the diagonals. Please help me. please see attached.

if (RowNo() = ColumnNo(), LightRed(),

If(RowNo() <ColumnNo(), Green()))

[#5]

Found the answer.

If (RowNo() = ColumnNo(), White(),

If(RowNo() < ColumnNo(), LightRed(100),

If(RowNo() > ColumnNo(), LightGreen(120))))