Preserve conditional formatting in Mac pivot table
Please add the conditional formatting "Apply Rule To" feature to Mac Excel. This is already in Windows. It is insanely frustrating that I need to re-apply the conditional formatting to every column every time I expand a pivot table or add data or really do anything to the pivot table. Thank you.
I figured out a workaround. Excel does not maintain the conditional formatting if I specify an entire column. Instead, I need to select the range containing data manually.