I am setting a conditional formatting for a column D:D for example. (Going to call it CC)

Then I add a row in between, lets say row 4, BOOM. The whole CC for that column breaks..
When I open the CC I see that it split the range to C1:C3,C5:C106..

Same problem happens with pivot tables. There even when changing from one filter to another, it will break! Yes, I know I can set columns inside the pivot table instead, but I am trying to understand why does this happen.

I can't even imagine for whom such a stupid functionality could be useful.. If I set a CC for the WHOLE column, would I want the CC not to apply for the row just because I added it now??

Thanks