B
Bob
I find that if I create a conditional format at one cell and then copy that
to a multitude of others, the variable references within the conditional
format will not adjust accordingly. For example:
At cell A1, I have the conditional format of "=IF(A1>0,1,0)". If I copy
this to cell B2:B3 (in one stroke), I will find both cell B2 and B3 to have
the same formula "=IF(B2>0,1,0)". This of course is fine for cell B2, but
it is not fine for cell B3. I would expect cell B3 to reference itself; not
cell B2.
Another problem is that if the receiving cells should have a conditional
format previously in place, the copy from A1 to B2:B3 will append to the
preexisting conditional format as opposed to overwriting them. The only
circumvention I have for this bug is to clear any possible conditional
format before I paste to the receiving cells, B2:B3.
So, how do I resolve this apparent bug in Excel?
btw, this bug is not present in Excel 2003.
Thanks,
Bob.
to a multitude of others, the variable references within the conditional
format will not adjust accordingly. For example:
At cell A1, I have the conditional format of "=IF(A1>0,1,0)". If I copy
this to cell B2:B3 (in one stroke), I will find both cell B2 and B3 to have
the same formula "=IF(B2>0,1,0)". This of course is fine for cell B2, but
it is not fine for cell B3. I would expect cell B3 to reference itself; not
cell B2.
Another problem is that if the receiving cells should have a conditional
format previously in place, the copy from A1 to B2:B3 will append to the
preexisting conditional format as opposed to overwriting them. The only
circumvention I have for this bug is to clear any possible conditional
format before I paste to the receiving cells, B2:B3.
So, how do I resolve this apparent bug in Excel?
btw, this bug is not present in Excel 2003.
Thanks,
Bob.