PDA

View Full Version : Modify conditional formatting in multiple cells



jwood
06-25-2017, 09:50 AM
Hi -

I have several similar worksheets in which I want to change all of the cell colors that are the dark green to the lighter green (visible in other parts of the worksheet) in order to make them easier to read. The problem is that the cell colors are set by conditional formatting. I seem to be only able to make this modification one cell at a time, or sometimes one column, at a time. In some parts of the page I'm not even able to highlight multiple rows or columns. If I select the whole worksheet, the conditional formatting does not show.

I'm attaching one of the workbooks so as to make more clear what my problem is. All I want to know is how to change that darker green to the lighter green without losing any other formatting, values, or content.

Any help in showing me how to do this will be greatly appreciated.

Thanks, Jack

Bob Phillips
06-25-2017, 12:00 PM
Dim i As Long

With ActiveSheet.Range("C4:K34")

For i = .FormatConditions.Count To 1 Step -1

.FormatConditions(i).Delete
Next i

.FormatConditions.Add xlCellValue, xlBetween, 1, 110
.FormatConditions(.FormatConditions.Count).Interior.Color = RGB(0, 255, 0)

.FormatConditions.Add xlCellValue, xlBetween, -1, -110
.FormatConditions(.FormatConditions.Count).Interior.Color = RGB(255, 0, 0)

.FormatConditions.Add xlCellValue, xlBetween, "INT", "INT ZZZ"
.FormatConditions(.FormatConditions.Count).Interior.Color = RGB(255, 0, 0)
End With