Formulas in conditional formatting

[PP]

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

 

[Jerry Sullivan]

Hi,

That's unusual. Some more info might help someone diagnose the problem.

I assume you don't have any absolute references in your formula. (not BV$6>L6).

Could you describe exactly how you are copying the cell down from W6 to the cells below it?

What version of Excel are you using?

Is this formula a typo?
=BV6 =BV6=L6
If not, please explain what you are doing here.