How to get colour background at last column No in Pivot

[neeraj_gupta]

I am trying to get Last Column No Colour Red in Pivot

I Have written below script but i am not getting all correct No.

Please help me...

if(ColumnNo()=1,Green(),

if(ColumnNo()=Max({<GRADE>}aggr(nodistinct max({<GRADE>}distinct GRADE),State)),red()

))

[Anil_Babu_Samineni]

Neeraj Gupta wrote:

I am trying to get Last Column No Colour Red in Pivot

I Have written below script but i am not getting all correct No.

Does simply red() for BG color not working. Or u mean last row?

[neeraj_gupta]

last row

[isingh30]

Try like this -

=IF(Product = 'C' and Sales = 17, LightRed())

Let me know.

Thanks.

[isingh30]