Format Table style with alternating colour not working ("zebra" format)

Copper Contributor

I have a file with tables and it's impossible to get the alternating fill colours for rows (aka 'zebra' format!) to display properly: odd and even rows have the same fill format.

What i want - zebra

Arnaud1995_0-1677676783461.png

 

The only format i can get for this particular table is 'non-zebra':

Arnaud1995_1-1677676783462.png

 

The table format pull down menu only shows formats with non alternating rows (although header and footer row can be of a different format).

 

For this table the format menu shows only non zebra options:

Arnaud1995_2-1677676783469.png

 

That file has other tables with zebra formatting ok for which the format menu shows zebra options are well:

Arnaud1995_3-1677676783481.png

 

I tried a make a custom zebra format, the preview shows ok as below but then the table then displays with same fill format for odd and even rows:

Arnaud1995_4-1677676783483.png

 

Can you advise how to fix without having to rebuild my whole complex file from scratch?

 

2 Replies

@Arnaud1995 

By default I have zebra format creating the table

image.png

Alternatively you may always apply conditional formatting like

image.png

 

Thanks Sergei but that particular file doesn't have the zebra in the table format menu and conditional formatting would be too cumbersome for this complex file.