Hey Everyone,

I am not sure if this is possible to do in VBA but could use some guidance. I have a Macro Enabled workbook A that contains hundreds of conditional formatting rules across several tabs. This workbook serves as a template. I am trying to find a way to export or print out all the conditional formatting rules including formula and named range references, range of cells the rules apply too, color and font etc ) to a separate worksheet which can than be copied and pasted into a new workbook and have a macro re-import all the conditional formatting rules by referencing this output sheet.

I can't post links yet but Extend Office has post on how to "Print all Conditional Formatting Rules" to a list but it does not account account for rules if the cell is blank, or include any formatting such as the color, font, boarder etc and also only does one tab at a time. I'd like to be able to export all the rules for the entire workbook and display all the possible formatting rules and re-import these to a operate workbook.

Appreciate any help