Table formatting new rows oddly

Designated Tables (a.k.a. "lists") in excel can be set to auto format and add formulas to new rows as you add data.  That's fine.  But one particular table is changing the fill color for certain cells in the row, for unknown reasons.  At one point, the bottom row of that table was that color (the whole row).  But not any more.  Is there a way to fix this?
shachoAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ken ButtersCommented:
Can you attach an example?  It's going to be difficult to guess what is happening otherwise.

My first guess would to examine the cell for any conditional formatting.
0
Zack BarresseCEOCommented:
Hi there,

Table formatting is a style. This means it won't always overwrite all underlying cell formatting unless you expressly tell it otherwise. With a cell in the table selected, go to the DESIGN tab, find the selected Table Style, right-click it, select "Apply and Clear Formatting".

By default, table row banding is every other row. However, you can change this by changing the Stripe value of the style. There's a whole chapter dedicated to table styles in my new book.

Regards,
Zack Barresse
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
shachoAuthor Commented:
Seems to have been some bugginess with the interaction between the Table style and Excel's setting for copying formats automatically in normal ranges.  By setting a new table style, adding a row, setting it back, then deleting the row I was able to exorcise the weirdness on those specific columns.
0
Ken ButtersCommented:
From your description, it sounds like Zack hit it spot on.    Your table formatting will NOT override any formatting that you have set for "Normal" ranges.

I put "Normal" in quotes, because in a new worksheet, there should not be any formatting present, and you wouldn't see this behavior.  If you follow Zack's instructions above, and remove all formatting from your Normal ranges, then you shouldn't see that formatting bleed into your table.
0
shachoAuthor Commented:
oops - thought i had closed this already.  thanks for you comments!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.