Insert Cut cells results in conditional formatting errors - why?


G

Guest

Excel 2000: large spreadsheet that include many cells w conditional formatting.

Operation sequence: (1) Select Column Y and Ctrl+X. (2) Select cell X1, and
'insert cut cells'.

ERROR occurs in all columns to the right. Conditional formatting for all of
the columns shift one column to the right. Makes no sense.
This is unrelated to formulas being updated. The condtional formatting has
literally moved to cells that did not have conditional formatting before the
above operations.
 
Ad

Advertisements

K

Ken Wright

If you cut and then insert, Excel will shift the cells where you insert to
the right to make way for the new cells coming in. Why wouldn't you expect
the formatting to move. If you physically move the cells, then the
formatting will go with them.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 
Ad

Advertisements

G

Guest

I guess the description of the problem was not clear enough. No problem.
I isolated the problem and tested the procedure in EX2000 & EX2003.
It is a bug in EX2000.
Microsoft has not documented this bug but two very related bugs are
documented in MS Article 171237 (EX97) and Article 268412 (EX2001 for Mac).
Thanks. No more help required.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top