C
Code Numpty
Is there a way in which to find all cells on a worksheet that have
conditional formatting applied to them?
conditional formatting applied to them?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
G
Gary''s Student
Edit > Goto > Special... > conditional formats
M
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
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
C
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.
Gary''s Student easy and simple one was perfect for what I need. Thanks to
you all.