Forum Discussion
Is it possible to create a macro for conditional formatting?
So I have conditional formatting rules located throughout my spreadsheet, but every time I add a row, the formatting in the rest of the columns doesn't apply to the new row. I simply use format paint...
Danger_SF so inserting rows should include the formatting but I know the whole conditional formatting is touchy and yes can result in numerous copies of rules an such. As such, about a year ago I created just such a workbook. The attached workbook has a sheet called conditional-formatting with a number of macros that will enable you to 'read' the existing CF rules, clear all the existing CF rules, and Apply the 'rules' defined in that worksheet. hover over row 1 to see how that column of information should be formatted.
I include no guarantees but would appreciate feedback and if there is interest I could continue work on it.