Financial highlighting - in pivot table

[Daniel_Moore]

I am trying to get this highlighted effect in QV:

The closest I could get was in this QVW....

Any ideas?

Thanks!

[vivek_niti]

Hi,

Please find the attached file.

Step1: Enable the Design Grid.

Step 2: Go to Custom Format cell by going into the properties drop down of the chart

[Daniel_Moore]

Did you mean to send a new file? It looks the same to me as the one I originally posted?

[Daniel_Moore · Accepted solution]

I had success using the RowNo() function:

=If(Even(RowNo(TOTAL)), RGB(255, 255, 255), RGB(204,204,204))

Much more readable.