VBA show Conditional Formatting Rules

[VenturSum]

Team,

I loop thru all worksheets and then thru all cells.
I copy into a new worksheet the cell address where: Cell.FormatConditions.Count > 0
In other word, I capture the address of cells that have conditional formatting.

I need to list the Rules for each conditional format in this new worksheet
because I'm looking for any rule based on a word as opposed to a value.

How can I call the Rule of each conditional format?
E.g.:

Dim sRule as String

For j = 1 to c.FormatConditions.Count

    sRule = c.FormatConditions(j)._____ [COLOR=Red]<-- Something to show the rules[/COLOR]
   'Do something to save sRule in another worksheet.

Next j

PLEASE Help? This is KILLING me!

Thank You,
John

 

[venkat1926]

did I understand your requirements
you want to find out in a sheet which cells are having "conditional formatting"

In that case why do you need a macro. see this url

http://office.microsoft.com/en-us/excel/HP052002011033.aspx