Forum Discussion
Solved
Conditional formatting - advanced
Hello dear Excel Community, I need to be able to copy the same formula used in a cell in a row 2 that says if there is a value in A2 then B2 cell gets highlighted. I have to repeat the same s...
Hi bzbz994
I assume that you have used absolute references in your conditional formatting rule. Instead, you would need to use mixed references, that only fix the column A, but not the row to.
Example:
Hi bzbz994
I assume that you have used absolute references in your conditional formatting rule. Instead, you would need to use mixed references, that only fix the column A, but not the row to.
Example:
Thanks very much Martin, this was actually the problem, my formulas were based on $A$2 instead of $A2. It is very easy now to do what I wanted now. Have a nice day.