Copying conditional formatting formulas

Hi and welcome to the forum

Instead of using the format painter, you can just specify the range in the "applies to" box for each rule.

The reason that each row;s CF seems like it is looking at C2, is because that is where the initial rule is being set - all other rows withing the CF range take their queue from that cell, so all is well, thats how it is supposed to work

Hi Ford,

Thanks for the welcome and quick response!

I see I've made a huge mistake in the orginal post, mixing up rows and columns. Hadn't had my coffee yet I've corrected it, could you please have another look?

If I understand correctly though, the CF takes it's intructions from that first initial rule (based on cell C2). When you copy it down using format painter, it then takes the info from the cell in the column it initialy refered to, but applies it to the specific row it's painted to? Even though the formula still reads it's refering to C2, it actually refers to C16?

I'm so sorry if the question is a bit vague and confusing, English is not my native language