I want to create many custom conditional formating rules that only differ in some values. Is there any way to export the conditional formating rules to a .txt-file, edit it, and import it afterwards? Or a way to directly edit the rules as text? If I use the GUI-way to create all these rules, it takes way to long.
You can use VBA - but you need some logic to figure out how to change the rule, or use a table of values to insert into the rule in sequence.
Bernie Deitrick
Excel MVP 2000-2010
If you select a CF formatted cell, click on Conditional Formatting, select Manage Rules, Double Click on one of the conditions, and then click into the formula. You can now Edit the formula.
HOWEVER, if you move the cursor, it will screw up the formula. Notice that, in the bottom left corner on the Status bar, it will say "Enter". If you press F2, it will change to "Edit". You can now edit the formula as you would a formula in the formula bar. You can press Ctrl-A to select all the text, and Ctrl-C to copy it. You can then, if you wish, Paste it into another condition and edit it.
I think, if you wanted to automate the export and/or import of the conditions, you would need VBA. I suspect that might be tricky.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
TMS: what you said is only true for the "Applies to"-column in the Conditional Formating Rules Manager. However I also need to edit the colorcode (or at least copy the whole rule, not just the "Applies-to"-formula).
Bernie: Okay, I guess I will learn VBA then. Thank you
You don't need to learn VBA - not an easy task. You can always describe what you want in the macro, and get code that you can use or easily modify.
Alright, thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks