Copying conditional format rules to another row

[slopez94]

Hello, everyone.

I currently have conditional formatting highlight rules in column D, the rules are to highlight the cell yellow if the number in the cell is 75% or more of the value of the cell beside it on row E, highlight orange if greater than 90%, and highlight red if greater than.

The problem I am having is that when I copy the table and paste it beside the existing table, it is keeping the existing conditional formatting rule from the original cell. In the example below, K2 should be orange because it is greater than 90% of L2, but it is red because D2 is greater than E2 and when copying that table over the rules are still looking at row D & E.

The first table will serve as a template with conditional formatting, I would like to be able to keep pasting tables beside each other but I would like for the conditional formatting to now acknowledge the value of the newly assigned rows rather than the original rows. Can anyone help?

I greatly appreciate the help.

 

[pjmorris]

Assuming that your using a formula to define the CF I suspect that the rules have absolute references rather than relative. Remove relevant '$' and recopy and it should work. Post a copy of the formula's if that doesn't solve the problem.

 

[slopez94]

Assuming that your using a formula to define the CF I suspect that the rules have absolute references rather than relative. Remove relevant '$' and recopy and it should work. Post a copy of the formula's if that doesn't solve the problem.

That worked! I was using formulas and the formulas were pulling absolute value, I removed the $ from the formulas and it is working perfect now. Thank you so much!

 

[pjmorris]

my pleasure, happy to help. grateful if you could mark it as the answer.

Regards