Change all Conditional Formatting At Once?

[mhenk]

I have a sheet with a fairly large amount of conditional formatting (all the same format, different conditions).

I would like to quickly change all of the (conditional) formats, but leave the conditions as is.

Can anyone think of a quick way to do this?

 

[mhenk]

You are correct, if your conditional formats (CF's) are varied, you can't do them all at once.

I was able to change CF's in groups.
If you have very divergent CF's, you will have to work with just similar CF's, like all CF's in one column.

Ugg.

That's what I was afraid of.

 

[pgc01]

Hi

If your conditional formats (CF's) are varied you can also loop through them and change them one by one with vba.

Example, assuming that it's the colour of the first condition that you want to change (even if the conditional formatting conditions vary):

Sub ChangeCFormat()
Dim rRng As Range, rcell As Range

Set rRng = Cells.SpecialCells(xlCellTypeAllFormatConditions)

For Each rcell In rRng
    With rcell
        If rcell.FormatConditions.Count > 0 Then _
            .FormatConditions(1).Interior.ColorIndex = 3 ' Red
    End With
Next rcell
End Sub

Hope this helps
PGC