Use vba to keep conditional format ranges even when rows deleted?

[lilsnoop]

Hello,

I have a workbook that has several conditional formats that extend down 2500 rows. If I use a macro to delete rows and condense data the conditional format range changes. Is there anyway to maintain the ranges through vba even when rows are removed? Ideally I'd like to keep this range for all conditional formatting: Thank you!conditional format.jpg

[zzzeddy]

Hi

If you defined your 'Applies to' range as entire columns, =e.g. =$A:$D
..then you wouldn't have to worry about rows being deleted or inserted.

Of course, you might need to amend your formula to ignore row 1 etc etc etc

zeddy

[6StringJazzer]

I was going to say the same thing but based on those rules, they won't fire for row 1 anyway.

[lilsnoop]

Excellent suggestion! Thank you both for your input!