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

Highlighted

It worked!  Thanks so much.

Great! You resolved my old mystery.

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

Related Conversations
Taking values from certain rows based on data input
Drakerla in Excel on
5 Replies
How to SUM Data from non-regular rows
Andy_Przybysz in Excel on
1 Replies
Copy/paste no longer working in Excel
Jon Firooz in Excel on
76 Replies
changing Date format in a pivot table
ahmad ali in Excel on
12 Replies