Forum Discussion
Copying Conditional Formatting referencing a different cell
Is it possible to copy a conditional formatting changing the reference cell each time:
Example:
I want to highlight the value whenever the cell value of F6 is not between -G6 and G6.
then I want to go to the next row have the same thing happen using F7 is not between -G7 and G7
You can use the Format Painter to copy all formatting, including the conditional formatting rules.
Make sure that your rule refers to -G6 and G6, not to -$G$6 and $G$6.
Alternatively, select F6, then click Conditional Formatting > Manage Rules... on the Home tab of the ribbon.
Expand the Applies to range from =$F$6 to - for example - =$F$6:$F$100.
Again, make sure that the rule refers to -G6 and G6, not to -$G$6 and $G$6.
This is the rule I have created:
When I copy it to the next one I get this:
I am not sure what is going wrong.
Sjohnson1975, you are comparing K6 to K6, that's why it's wrong. (Applies to =$K$6:$K$7).
You should apply conditional formatting to a different range, let's say $J$6:$J$7.
Check my screens.
Let me know pls if that works for you.
