Hi,
I have 4 formulas applied to W6 as conditional formatting:
=ISBLANK(W6) = No formatting
=BV6>L6 =Turn green
=BV6<L6= Turn red
=BV6=L6 = Turn orange
When I copy them down though the cell references don't seem to change. Eg when copied down w9 the formulas are still referencing BV6 instead of BV9. What am I doing wrong??
I have 4 formulas applied to W6 as conditional formatting:
=ISBLANK(W6) = No formatting
=BV6>L6 =Turn green
=BV6<L6= Turn red
=BV6=L6 = Turn orange
When I copy them down though the cell references don't seem to change. Eg when copied down w9 the formulas are still referencing BV6 instead of BV9. What am I doing wrong??