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