SOLVED
Home

Banded Rows in Excel not working

%3CLINGO-SUB%20id%3D%22lingo-sub-195228%22%20slang%3D%22en-US%22%3EBanded%20Rows%20in%20Excel%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-195228%22%20slang%3D%22en-US%22%3E%3CP%3EUnder%20the%20Design%20tab%2C%20I%20selected%20the%20%22Banded%20Rows%22%20option.%20When%20I%20did%2C%20the%20Table%20Styles%20preview%20then%20showed%20banded%20rows.%3C%2FP%3E%3CP%3EThen%20when%20I%20tried%20to%20apply%20a%20style%20that%20had%20banded%20rows%2C%20the%20banded%20rows%20did%20not%20apply%20to%20the%20table.%20What%20went%20wrong%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-195228%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-215021%22%20slang%3D%22en-US%22%3ERe%3A%20Banded%20Rows%20in%20Excel%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-215021%22%20slang%3D%22en-US%22%3E%3CP%3EGreat!%26nbsp%3BYou%20resolved%26nbsp%3Bmy%26nbsp%3Bold%20mystery.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-195342%22%20slang%3D%22en-US%22%3ERe%3A%20Banded%20Rows%20in%20Excel%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-195342%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20worked!%26nbsp%3B%20Thanks%20so%20much.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-195268%22%20slang%3D%22en-US%22%3ERe%3A%20Banded%20Rows%20in%20Excel%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-195268%22%20slang%3D%22en-US%22%3E%3CP%3EEmily%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20guess%20that%20the%20table%20already%20has%20its%20own%20format.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20select%20the%20table%2C%20then%20go%20to%20%3CSTRONG%3EHome%3C%2FSTRONG%3E%26gt%3B%26gt%3B%20%3CSTRONG%3EFont%3C%2FSTRONG%3E%26gt%3B%26gt%3B%20%3CSTRONG%3EFill%20Color%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3EAnd%20select%20%3CSTRONG%3ENo%20Fill%20%3C%2FSTRONG%3Eas%20shown%20in%20the%20below%20screenshot%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F34420i65E6EEEF3905E220%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22No%20Fill.png%22%20title%3D%22No%20Fill.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3CP%3EHaytham%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-847082%22%20slang%3D%22en-US%22%3ERe%3A%20Banded%20Rows%20in%20Excel%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-847082%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20not%20working%20for%20me.%26nbsp%3B%20Still%20no%20alternating%20row%20color.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Emily Ross
New Contributor

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?

4 Replies
Solution

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:

 

No Fill.png

 

Hope that helps

Haytham

It worked!  Thanks so much.

Great! You resolved my old mystery.

This is not working for me.  Still no alternating row color.

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies