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.

Highlighted

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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
50 Replies
Extentions Synchronization
Deleted in Discussions on
3 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
32 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
15 Replies
Discussion - Updating our interface with Fluent touches
Elliot Kirk in Discussions on
102 Replies