Conditional format cells moving

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I have a problem that I have reduced to a very simple situation for the
purposes of explanation.

In cells A1:A6 I have the numbers 1 to 6. A5 is conditionally formatted to
show red if the cell value is greater than 1. This is what I will call the
starting position. I now select row 2, and whilst holding down SHIFT I drag
row 2 and drop it between rows 3 and 4. My number sequence is now
1,3,2,4,5,6 and A5 is still red, as I would expect. Undo returns me to the
starting position.

Next I select column B and apply a conditional format to show blue with the
formula =(ISNUMBER(A1)) . Cells B1:B6 turn blue as expected. Now I repeat
what I did before - I select row 2, and whilst holding down SHIFT I drag row
2 and drop it between rows 3 and 4. My number sequence is again 1,3,2,4,5,6
but something quite unexpected has happened to the conditional formatting.
The red format has moved from A5 to A6, and B4 has completely lost its
conditional format!

I use Excel97 and would be interested if anyone:
a) with this version can confirm that this happens;
b) can say if it happens with a later version;
c) can give any kind of explanation.

Thanks in anticipation.
 
Paul

I've followed your instructions with Win98SE and XL2K
The first half matches with your results.
The second half doesn't. When I drag A2 to make my sequence is 1,3,2,4,5,6
my CF moved from A5 to A6 and the Bs stay as they are. When I drag A2 back,
the CF on A6 disappears.
Hope this helps!!!

Andy
 
Andy,

Thanks for this input. In fact, I was dragging the whole of row 2 to get the
results I described. I've now tried it as you say, dragging just cell A2,
and I get exactly what you got. When the CF disappears from A6, it actually
ends up on A7, so it appears to move down one cell each time.

Does anyone else have an explanation?
Paul
 
Back
Top