T
Thief_
I've got a workbook which I have added a new worksheet. I copied text from
another worksheet where the data was Filtered from a list of many rows- no
formatting. I pasted the data into the new worksheet, formatted only the
cells with data, using different background colours for each row B6
20.
I then added some text by typing onto the cells in G10:H20 and the cells
magically aquired the same background colour as the data in B620.
Depending on which row I typed the new text in, the corresponding background
colour in the same row of data in B620 appeared in my new cells.
There's no Conditional Formatting and no macros- so what's going on? It's
not a religious day today, is it?
XL2003
another worksheet where the data was Filtered from a list of many rows- no
formatting. I pasted the data into the new worksheet, formatted only the
cells with data, using different background colours for each row B6
20.I then added some text by typing onto the cells in G10:H20 and the cells
magically aquired the same background colour as the data in B6
20.Depending on which row I typed the new text in, the corresponding background
colour in the same row of data in B6
20 appeared in my new cells.There's no Conditional Formatting and no macros- so what's going on? It's
not a religious day today, is it?
XL2003