Hello,
I have created a Pivot Table. In this table, using conditional formatting I have linked the format to the values in one of the columns (it is not applicable to use formatting of the pivot itself).
However each time I refresh the table, the range of the conditional formatting changes.
Is there a way to prohibit changes to the range of the conditional formatting?
I have created a Pivot Table. In this table, using conditional formatting I have linked the format to the values in one of the columns (it is not applicable to use formatting of the pivot itself).
However each time I refresh the table, the range of the conditional formatting changes.
Is there a way to prohibit changes to the range of the conditional formatting?
