Forum Discussion
Is it possible to create a macro for conditional formatting?
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.
What exactly is the problem?
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.