PDA

View Full Version : How to highlight conditional formatting



coltaalex
08-02-2010, 05:53 AM
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
08-02-2010, 06:30 AM
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
08-02-2010, 06:46 AM
Than you very much Mr. XLD, it work, thank you
have a great day

mikerickson
08-02-2010, 06:59 AM
In 2004 and before, under the Edit menu item >Goto>Special has a Conditional Format option.

Bob Phillips
08-02-2010, 08:32 AM
Mike's suggestion uses SpecialCells(xlCellTypeAllFormatConditions). Help suggests that xlCellTypeAllFormatConditions is cells of ANY format. Once again help proves itself as anything but ...