May 18 2018 06:38 AM
Under the Design tab, I selected the "Banded Rows" option. When I did, the Table Styles preview then showed banded rows.
Then when I tried to apply a style that had banded rows, the banded rows did not apply to the table. What went wrong?
May 18 2018 08:19 AM
SolutionEmily,
I guess that the table already has its own format.
Please select the table, then go to Home >> Font >> Fill Color.
And select No Fill as shown in the below screenshot:
Hope that helps
Haytham
Sep 10 2019 09:23 AM
This is not working for me. Still no alternating row color.
Dec 09 2020 12:54 AM
@geoperkinsTurns out yo need to have a field under "Values" in your Pivot Table to get banded rows...
I know... it is a feature :)
Jan 13 2021 06:53 AM
Jan 14 2021 03:42 PM
@JamesBalisciano I agree with you. My first thought was to just hide that extra column but that caused the issue again so the workaround I found was to set the column's width to 1 pixel so not really hidden but "invisible" to the eye.
Feb 07 2021 07:39 AM
Jun 29 2021 08:57 AM
Sep 30 2021 10:05 PM
Yes it worked very well thank you @Haytham Amairah
May 01 2022 04:57 AM
May 18 2018 08:19 AM
SolutionEmily,
I guess that the table already has its own format.
Please select the table, then go to Home >> Font >> Fill Color.
And select No Fill as shown in the below screenshot:
Hope that helps
Haytham