Copying Condtional Formatting

[TMILJVIPM]

Guys,

I got a problem that I need some help with. On several of my sheets I use condtional formatting and I just realized that copying the cell with the condtional fromatting doesnt work like it does with the formula. Lets say cell K10 has the formula and the conditonal formatting in it. Well if I copy the cell and paste it from K11:K250 the formula automatically moves with each cell like it should but the conditional formatting is still linked to cell K10. Is there a way to copy the conditional formatting and paste it in all the cells and make it apply to that specific cell?

 

[Norie]

There's no pattern to the ranges there.

You want to go K to H to Q to T to W to AA?

It seems like you are moving 2 columns each time but the last one where you are moving from W to AA which is 3 columns.

 

[TMILJVIPM]

There's no pattern to the ranges there.

You want to go K to H to Q to T to W to AA?

It seems like you are moving 2 columns each time but the last one where you are moving from W to AA which is 3 columns.

That is correct, here's a look at my sheet and maybe it will give you abeeter understanding. Once again thanks for all your time!

http://wikisend.com/download/146886/Copy of MASTER COPY ESTIMATE TRACKER TOOL(2).xlsx

 

[APTEBB]

Hi,

"Thanks, but I tried already and it comes up with a message of "cannot use relative references in conditional formatting criteria for color scales, data bars, and icom sets"

I have the same issue....

I am trying to do exactly the same as you but to no avail!

Can anyone help on this matter

Regards
Mike