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
Highlighted
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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies