Conditional Formatting settings

[MacroAlan]

I have found several fine examples of setting Conditional Formatting using VBA.

What I would like to do is capture the existing rules settings (I'm looking at thousands of rows by 94 columns).


Is this even possible?

Any ideas

 

[kalikj]

Alan, "capture" in what way? As in use the formatting from a given range to apply to another range?

 

[MacroAlan]

I want to capture the settings so that when I add a bunch of rows and columns, I can set the range in code.

Now that I think about it, copying down in VBA would/might serve the same purpose.