[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 104
  • Last Modified:

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?
0
shacho
Asked:
shacho
  • 2
  • 2
1 Solution
 
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
 
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

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now