Good day.
I have managed to get my named range "Data_Range_1" to equal $E2:$H2 (only columns are locked) but when I try to use the "Data_Range_1" named range in a conditional formatting formula, it does not work as intended - it seems to revert back to $E$2:$H$2, based on what I can see with the cells being highlighted in the range.
My pivot table changes, based on the category selected in a slicer, so I need the conditional formatting range (with only the column locked) to dynamically change with it, which it is not, despite the Data_Range_1 value being what I want it to be.Please Login or Register to view this content.
I have been searching hours for a solution without any luck...
Any assistance in this matter will be greatly appreciated.
Kind Regards,
Jason
Bookmarks