SOLVED

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
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
Highlighted
Best Response confirmed by Emily Ross (New Contributor)
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.

Highlighted

Great! You resolved my old mystery.

Highlighted

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