A
A-JA
Recently upgraded to v2003 from 2002. This was not a problem in previous
version. I'm using the same spreadsheet. Example: 4 columns of data,
comparing two sets of data Columns A/B and Columns C/D. Columns A and C are
identifiers for the data in B/D. Column A is the master list of all IDs that
should exist. Both A/C are sorted numerically. Column C/D has missing data.
Cells need to be inserted into C/D so the ID in C aligns with the matching
ID in Column A. In v2002, I set up a conditional format in Column A to show
when the value in the cell of Column C (same row) did not match Column A. I
could quickly see where new cells needed to be added to Column C/D. (For
instance cell value A7 <>C7). Column A's references in subsequent cells
(A8...) still looked to the same row (A8<>C8). Now in v2003, whether or not
the reference is absolute (cell value A8<>$C$8) and cells are entered in
C/D7, then the CF in A8 insists on changing to A8<>$C$9 --it needs to
continue to look at the value on its same row (A8<>B8). I tried resetting
the CF to a formula instead of cell value but that didn't work either.
Reversing the CF to be in Column C did the same sort of behavior. This is
really frustrating and time consuming as I now must recopy the correct
references throughout the entire column A all over again after every
insert/deletion in column C. How can I get the CF to function as it did in
v2002?
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...c3f6102&dg=microsoft.public.excel.crashesgpfs
version. I'm using the same spreadsheet. Example: 4 columns of data,
comparing two sets of data Columns A/B and Columns C/D. Columns A and C are
identifiers for the data in B/D. Column A is the master list of all IDs that
should exist. Both A/C are sorted numerically. Column C/D has missing data.
Cells need to be inserted into C/D so the ID in C aligns with the matching
ID in Column A. In v2002, I set up a conditional format in Column A to show
when the value in the cell of Column C (same row) did not match Column A. I
could quickly see where new cells needed to be added to Column C/D. (For
instance cell value A7 <>C7). Column A's references in subsequent cells
(A8...) still looked to the same row (A8<>C8). Now in v2003, whether or not
the reference is absolute (cell value A8<>$C$8) and cells are entered in
C/D7, then the CF in A8 insists on changing to A8<>$C$9 --it needs to
continue to look at the value on its same row (A8<>B8). I tried resetting
the CF to a formula instead of cell value but that didn't work either.
Reversing the CF to be in Column C did the same sort of behavior. This is
really frustrating and time consuming as I now must recopy the correct
references throughout the entire column A all over again after every
insert/deletion in column C. How can I get the CF to function as it did in
v2002?
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...c3f6102&dg=microsoft.public.excel.crashesgpfs