conditional format starts to break up

[jvoss]

i have MS 2019, Conditional formats in a works sheet. when a row is deleted the Conditional formatting brakes ie F1:F1000 is set but i delete F20. i now have CF as F1:F19,F21:F10000. the CF now skips F20. i have to reset every time. and with 10 CF it is a real problem. any solutions?

What is the problem is this MS2013 and newer, I never had this in 2010..

 

[bobsan42]

How do you delete a row?
It sounds more like removing the formatting from this row.

The CF refersTo range does NOT "break" if you simply DELETE a row or column from within the range. You should end up with CF over F1:F9999.

 

[jvoss]

How do you delete a row?
It sounds more like removing the formatting from this row.

The CF refersTo range does NOT "break" if you simply DELETE a row or column from within the range. You should end up with CF over F1:F9999.

fixed just select the new rows deleted. then select all. then select CF >clear selected> ok then reelect CF >this works sheet then select the rule then adjust the row number to remove the deleter rows. much easier then deleting the bs that is broken when deleting old rows between already CF rows.