I want to
1. Keep/Record the current conditional formatting I have applied (all formulas, rules and most importantly the cells they apply to)
2. Clear all Conditional Formatting
3. Reapply the Conditional Formatting from number 1. above.
This is to make up for routine copy and pasting which results in duplicated conditional formats. If there is a VBA to do this, i would greatly appreciate the assist!
Thanks!
Bookmarks