Delete all conditional formatting and coloring conditional on specific rows

[Paul_Hossler]

Hello Aussiebear,
exactly what I should have imagined to be honest.
lest you think that if I had known, I would have hidden it (I had absolutely no idea that I could get to such a problem with this office 2007).
Are you making fun of me, with all due respect to you and every single person on the site.

No one is making fun - many times there's a "WHY did that not work???" type of question that eventually turns out to a version difference where someone did not realize that Excel versions sometimes work a little differently.

It's just helpful to know what version someone is using (many people don't say anyway) so that if it works for me using 365 but not for you using 2007, then that's a start to investigate version differences (I should have looked sooner )

By the by, your workbook seems to work fine with your column number changes. What were you seeing that was not right?

I comment out the 365 CF format to force the .Interior verion to run and it seems to be as expected