Highlight cells in pivot table

[#1]

Hi

When i tried to compare with plan with actual, the heading column also got highlighted and when the cell value is zero for both actual and plan , cell is being highlighted (subsequent months)

Kindly refer the below screen shot

[crusader_]

Hi,

Just add isnull() or Exr<>0 exception for your highlight expression.

HTH.

Andrei

[#3 · Accepted solution]

Try diz...