Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Excel 2007 / VBA 6.5
Is it possible to delete a single conditional format? (My goal is to delete all except 2. I have tried to do so (code below) and receive a 1004 error. When recording a macro while deleting two of the formats, it appears to delete ALL of the formats, and then recreate the formats that remain. Here is the code I tried: ============================= Private Sub Worksheet_Activate() Dim i As Long With Worksheets("solver").Cells If .FormatConditions.Count 2 Then For i = 1 To .FormatConditions.Count - 2 .FormatConditions(i).Delete Next i End If End With End Sub =========================== --ron |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional format of entire row based on a single cell in row | Excel Worksheet Functions | |||
Setting an Icon Set conditional format for a single cell??? | Excel Discussion (Misc queries) | |||
delete single spaces | Excel Discussion (Misc queries) | |||
Conditional Format to Delete Row | Excel Programming | |||
delete columns with 0 in single row | Excel Programming |