How to highlight conditional formatting

[coltaalex]

I have an excel sheet and i want
to highlight or select all the conditional formatting cells
it is possible ?
i want to see what cells contain CF

[Bob Phillips]

For Each cell In ActiveSheet.UsedRange

If cell.FormatConditions.Count <> 0 Then

If rng Is Nothing Then

Set rng = cell
Else

Set rng = Union(rng, cell)
End If
End If
Next cell

If Not rng Is Nothing Then MsgBox rng.Address

[coltaalex]

Than you very much Mr. XLD, it work, thank you
have a great day

[mikerickson]

In 2004 and before, under the Edit menu item >Goto>Special has a Conditional Format option.

[Bob Phillips]

Mike's suggestion uses SpecialCells(xlCellTypeAllFormatConditions). Help suggests that xlCellTypeAllFormatConditions is cells of ANY format. Once again help proves itself as anything but ...