Highlight visable cells that are different in a pivot table.

[VBA learner ITG]

Hi all,

Can I please get your help.

What is the formula to achieve the following on a pivot table.

Highlight cells which are not the same value by ignoring only blanks cells and cells with a single value.

I only need to highlight cells where the number appears more than 2 times and when its different in columns B through to column G

 

[VBA learner ITG]

apologies, I should have also mentioned i did try using the below formula and applying a conditonal formatting and it didnt work as all cells were highlighted.

=COUNTA(RANGE)>=2