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...
I've tried removing the conditional formatting from the first of my many tabs that need this formatting, and then copying all of the data from that first tab into the tab you've labeled "Data" on your spreadsheet. None of the rules in the macro worked.
I've tried copying and pasting your macro text into a macro of my own, and changing the text in the macro from "Data" to the name of my tab, and that didn't work.
I've tried copying your CF tab from your spreadsheet into my spreadsheet and renaming my first tab "Data", thinking that would work. No success.
Long story short, I need instructions to get your macro to work in all of the tabs in my spreadsheet.
I'd have to see the workbook...