I create Conditional Formatting on whole columns. I should be able to insert, delete, blank within my range without Conditional Formatting breaking up into formatted sections which eventually causes some rows not to format correctly. I am constantly correcting the Conditional Formatting which is very time-consuming! It is such a handy tool but very frustrating tool to work with.