Preserve Conditional Formatting on Pivot table after updating the data

[gazmoz17]

Hi,

Via conditional formatting Ive created a highlight/search box. I type a string in M1 and it formats fill orange cells that contain the string.

I have set the formatting across the entire row (Col A:J) it works until the data is refreshed. After refresh the formatting is only Highlighting Column A. Column A is the basis of my formatting formula field "Product Description".

=AND($M$1<>"",ISNUMBER(SEARCH($M$1,$A3)))

Any help much appreciated.

 

[JADownie]

I was able to achieve what I needed with conditional formatting instead