Fill Color is added to additional rows

[Guest]

I'm using Excel 2007, and I've got a rather odd problem and do not know the
explaination for it. I'm adding information to an already constructed list
and as I add information to a row, I am filling the row in yellow so I will
know later which rows have added information.

However, in addition to the rows I've added information to, I now have some
rows where, cells that I do not have anything typed, are filled in yellow.
What is causing this odd issue? I have not deleted any rows or cells in this
sheet at all so I know it's not just a mis-alignment issue.

Thanks for any help.

 

[Nick Hodge]

Have you set this up as a 'table'? If so if you even temporarily 'add' a
row' it will add the formatting from above too. Just a thought

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/

 

[Guest]

A colleague took one look at my spreadsheet and figured out the problem. I'm
not sure if it's set up as a table or not. But what occured was that I added
the fill and then sorted based on the column I added information to so that
the cell with the new information and the fill would be added to the same
area of the spreadsheet as previous cells with the same information. When I
did the sort, it would sort based on the columns of data I've got, but then
that's where the selection would end, leaving "extra" cells with the fill
applied that stayed in the same position even though the cells with the data
were moved.