Find cells that are conditionally formatted

[Code Numpty]

Is there a way in which to find all cells on a worksheet that have
conditional formatting applied to them?

 

[Bob Phillips]

See http://xldynamic.com/source/xld.CFConditions.html

 

[Gary''s Student]

Edit > Goto > Special... > conditional formats

 

[Mike H]

Hi,

This will produce a list of addresses with conditional formats in column A.
Right click your sheet tab, view code and paste it in.

Sub marine()
x = 1
Set myrange = Cells.SpecialCells(xlCellTypeAllFormatConditions)
For Each c In myrange
Cells(x, 1).Value = c.Address
x = x + 1
Next
End Sub


Mike

 

[Code Numpty]

Thanks Guys! Many answers at the speed of light.

Gary''s Student easy and simple one was perfect for what I need. Thanks to
you all.