Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Alternating fill in table style or options won't show

Community Beginner ,
Nov 21, 2023 Nov 21, 2023

Ok, so I know that within the table styles there is an option for alternating row color. However, it seems that I can't get alternating row colors to show. My best guess right now is that somehow the fill color in the cell styles is stopping it from showing. I saw some other similar posts to this but the solutions in those cases were for you to set the cell style fill to "(ignore)". I only see that as an option if another color is set. So I select it, and the box goes blank (at which point "(ignore)" goes away). I'm attaching a screenshot of my table and cell styles to show they're both set up to what I believe is correct, but still no alternating row pattern is appearing on the cells in the red outline box.

Can anyone point me in the right direction? I am also wondering even if I get this to work what happens if the amount of rows I want to skip coloring on (headers) is variable? Sometimes there are two header rows and there could be anywhere from 3-4 potentially. I wouldn't want those to be alternating so I can't skip a set amount of rows in the options.

TOPICS
How to
1.2K
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Community Beginner , Nov 29, 2023 Nov 29, 2023

The only way I got this to work was to rebuild some of the styles relating to the background. I think I just had too many things trying to override it.

Translate
Community Expert ,
Nov 21, 2023 Nov 21, 2023

Yes, Cell Styles overwrite Table Styles. It's a simple, HTML-like behavior.

 

You will have to set your Cell Styles to a background of None/No Fill for table-based shading to show.

 

BTW, don't use [default] styles for either, or for any ID style. Create distinct, named styles for all elements.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Nov 21, 2023 Nov 21, 2023

CellStyles behave similarly to CharStyles + ParaStyles - they override what is defined in TableStyles.

 

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Nov 29, 2023 Nov 29, 2023

The only way I got this to work was to rebuild some of the styles relating to the background. I think I just had too many things trying to override it.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Jul 09, 2024 Jul 09, 2024

I had what appears to be the same problem. I could apply [Basic Table] style to a table, and then the alternating fill selected in my Table Styles > Fills options worked correctly. But when I used my custom table style, the alternating fill did not appear. I did have Cell Styles created and in use in my own custom table style. The way I found to fix it was to make sure all of my cell styles had the Cell Fill Color set to "(Ignore)". When it was set to "[None]", the alternating fill did not work. Note that once the Cell Fill Color is set to "(Ignore)", you will just see a plain white background in the field where the color usually is – there will be no word like "[None]" or "(Ignore)".

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Dec 07, 2024 Dec 07, 2024

This worked for me as well. Many other suggestions failed and a lot of time was wasted. Thank you.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Dec 09, 2024 Dec 09, 2024

I wish that would work for me -- I don't seem to have the option of "ignore" in the cell fill, no matter how I approach it.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Dec 09, 2024 Dec 09, 2024
LATEST

Judy, the context of the discussion above your comment is cell styles applied to columns, rows, and cells. Editing these has to be done a certain way in order to get the alternating table fill to show through. Are you having this trouble within a cell style?

Mike Witherell
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines