Copy a Pivot Table Custom Style to Different Workbook

How can you copy a pivot table custom style to a different workbook? There isn’t a built-in way to do that, but there is a workaround solution. There are instructions that worked in Excel 2013, and earlier versions (way back to Excel 2007). Those stopped working, unfortunately, but there’s an easy way to do this in Excel 2016 too.

Continue reading “Copy a Pivot Table Custom Style to Different Workbook”

Excel Conditional Formatting Colour Macro Problems

If you need to know what colour is in a worksheet cell, or a shape, you can check it manually, or use VBA code to find the colour number. There are conditional formatting colour macros too, but they’re a bigger challenge, and didn’t work for a project that I built recently.  Here’s what I was working on, and some of the Excel colour resources that I used along the way. There are links to download my sample file, and one from Visio MVP, John Marshall.

Continue reading “Excel Conditional Formatting Colour Macro Problems”