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...
Thank you both.
The attached represents the objective. Essentially applying colors to text for the most part.
See the attached workbook (you'll have to allow macros). I changed the layout of the CF sheet slightly.
There is a macro that will create or recreate the conditional formatting rules for the Data sheet.