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...
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. 