Hi guys,
After I change something to the pivot table's data source and refresh, the conditional formatting keep changes its range of where the formulas apply. Is there a way that I can lock this range regardless of what happens to the pivot?
Thanks in advance,
Jake
Bookmarks