Extracting conditional format from another workbook

[pingme89]

I would like to extract the conditional format of a cell from another workbook and programmatically recreate it. Is this even possible?
The workbook in question has many many conditional formats but it would be very difficult to get the right color codes and formulas from so many cells manually.

On the same thread, how can I extract information from another workbook regarding borders? Is there a way to test it and get the formatting information programmatically?

 

[rollis13]

As fare as conditional formating in this case in a macro you could use:.PasteSpecial Paste:=xlPasteAllMergingConditionalFormats.
Use the Macro Recorder to create a macro then adjust it (programmatically) as needed.

Sorry, no idea about borders.

 

[pingme89]

I know how to copy formats, but I want just the conditional formatting parameter data. I have no idea if this is even possible though.

 

[rollis13]

This macro by snb almost does what you are asking for (doesn't list the cell formating, only the range and rule): LINK

 

[rollis13]

Neither this one will show formatting: LINK

 

[rollis13]

Here, this has the complete output in Immediate pane: LINK

 

[pingme89]

Thanks. That solved my problem, well at least about the text alignment portion.