Forum Discussion
Solved
Banded Rows in Excel not working
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 ...
Emily,
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
geoperkinsTurns out yo need to have a field under "Values" in your Pivot Table to get banded rows...
I know... it is a feature 🙂
AmigoDeluxe thank you! That was the piece I was missing.
Unfortunate that I need to choose between adding a field I don't need and the formatting that I want.
Unfortunate that I need to choose between adding a field I don't need and the formatting that I want.
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.