GoodInSheets
New Member
- Joined
- Aug 21, 2024
- Messages
- 1
- Office Version
- 365
- 2021
- Platform
- Windows
Hello everyone,
I have pretty straight forward question, but just can't get it to work.
I want that conditional formatting is applied to the column range only, in Pivot table (and when the pivot table column range shrinks or expands due to changes in the main document that formating is only applied to the column range dynamically.
Now when the size of the table/column changes, the formatting is applied to this defined range AY17:AZ48 even though when applying conditional formatting I selected the column with down arrow only.
Thank you in advance
I have pretty straight forward question, but just can't get it to work.
I want that conditional formatting is applied to the column range only, in Pivot table (and when the pivot table column range shrinks or expands due to changes in the main document that formating is only applied to the column range dynamically.
Now when the size of the table/column changes, the formatting is applied to this defined range AY17:AZ48 even though when applying conditional formatting I selected the column with down arrow only.
Thank you in advance