This next tip I know causes a bit of frustration with Excel users, based on the number of times I have been asked about it. It is applying conditional formatting to a Pivot Table. The method of applying conditional formatting to a Pivot Table is not the same as applying it to a regular data set.
This is all working well for us, with the conditional formatting applied to cells D3:D8. But, if we were to use the same method in a Pivot Table anytime new data was added to the table then the formatting would not be applied to any new data.
That’s it, folks. I hope you enjoyed this instalment of Macro Monday.