Document (List) All Conditional Formatting Rules in Workbook

I am creating documentation on a rather complex workbook that contains many Conditional Formatting rules on most worksheets. Is there a VBA way to create a list of all the Conditional Formatting rules in a workbook?

Ideally, the resulting output would be a new worksheet named CF that has the name of the worksheet in Column A, the actual boolean formulas in Column B, and the range to which the rule applies in Column C.

Thanks in advance for your suggestions!

Wow! Thanks, Jerry. It works perfectly. tom

Thanks Jerry ,
Just Tried this in Excel 365 and it worked a Treat.
Hugh

Excellent, I have tried many fragments of VBA from various forums & this is the first one that has actually worked! thanks!

This is a great answer but some care should be taken. Not all Conditional Formats have a 'Formula1' property.

You can use a Select Case to avoid errors, for example (and by no means exhaustive):

Please Login or Register  to view this content.

XlFormatConditionType constants can be found at by searching on MS Docs (can't post a link to the URL!)