How to record/list all existing Conditional Formatting in a worksheet

Note: I am using Excel 2010

First, this is what I have figured out is possible to do:

1) Developer Tab - "Record Macro"
2) Home Tab - Conditional Formatting - Manage Rules...
3) Change "Current Selection" to "This Worksheet"
4) Click inside the Applied Range field of one of the rules. (A simple click, no typing!)
5) Click "OK" to exit.
6) Developer Tab - "Stop Recording"

The recorded macro now lists all of the conditional formatting code that is applied on the worksheet. With some tweaking, the code can be used to reapply the conditional formatting rules back onto the worksheet.

What I want to figure out is if it is possible to make a macro that can "record" all of the conditional formatting on a worksheet (like above) and list those rules out on a separate worksheet within the same workbook?

Currently all I can do is the above recording of the macro and then manually opening and copy-pasting the generated code to a new worksheet. I'm thinking I can use this new worksheet as a basis to re-apply conditional formatting whenever I have to remove formatting during the use of other macros. But it would be nice to be able to automate this part of the process.

To be clear, I do not want to replace conditional formatting rules with VBA code equivalents.
Also, I will be gone on a business trip for this week, so I will be only able to check things out on Friday night. Apologies for not being here to clarify any confusion this question may generate.

Thank you,

Monimonika

Hi fredlo2010!

Pretty sure I'm not answering your question correctly, but I would have to say there are two types of conditional formatting rules I use. They are the "Use a formula to determine which cells to format" and "Format only cells that contain" types.

The vast majority is the former type with custom formulas, since I typically use them to highlight when a cell's value is different from expected based on calculations from other relative cells. For example, if the quantity of an item today is different from what was expected given yesterday's starting quantity and usage.

These formulas tend to be a bit complicated, as I avoid using relative cell references and instead use INDEX(range,ROW()+r,COLUMN()+c) to refer to all relative cells, including the starting cell. This makes it much easier for me to keep track of and fix any splitting of the conditional formatting rules without having to worry about matching the relative cells to the correct ranges in the formulas.

ETA: Also, the cells in the applied range are typically not adjacent to each other.
ETA2: Another usage I have is for changing the font color of cells depending on if cells relative to them fulfill three criteria.