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...
One workaround is to turn a range in which you use conditional formatting into a table. Formulas and Conditional Formatting should be propagated to new rows automatically.
But it's definitely possible to create conditional formatting rules in a macro. But since there are so many different types of conditional formatting, it's hard to provide a one-size-fits-all solution.
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.
- Sorry for the delay. I have tried figuring out how to apply this to my spreadsheet with no success.
