Hello
I struggle with conditional formatting at the best of times but here I have a large pivot table with calculated power query measures and I would like to conditionally format each headline % column based on whether calculated difference is greater than (green fill) or less than (red fill) confidence interval.
I've attached a sample workbook. In my finished worksheet I would like to hide those columns used for conditional formatting (the 'difference' and the Confidence Interval) and just show the formatted headline % column. Does anyone have an idea of how best to achieve this?
Many thanks,
A
Bookmarks