Table style color half green

[acura123]

I made a table and I have the bottom half of the table half green and don't know how to convert it back to the standard alternating colors of green and white. I had a drop down list in one of the columns that I copied and pasted down the column and think that may have messed it up. Any thought how to fix this?


Thanks

 

[Peter_SSs]

With a copy of the workbook, try selecting the relevant section and format the cells with No Fill

 

[acura123]

With a copy of the workbook, try selecting the relevant section and format the cells with No Fill

View attachment 63242

That worked but how do I get my table alternating colors back?

 

[Peter_SSs]

.. but how do I get my table alternating colors back?

For me the table banding colours automatically returned.
Are you sure that what you are looking at is still part of a formal Excel table?
Go to the Formulas ribbon tab -> Name Manager and check the table name and what sheet/range it refers to

If that still seems all okay then back in your worksheet select anything in the table then on the Table Design ribbon tab, choose the design you want from the Table Styles section

 

[acura123]

Table range includes entire table, I changed the style which changes the style for the first half of the table with a solid color for the bottom half. I think the problem is in the fact that the drop down list was a table itself and when I copied and pasted the list box dow ln the page it must have taken on the properties of the list box table. So it's a nested table within a table.

 

[acura123]

I got it! I changed the fill to no fill and then when I looked into table tools, the banded rows was unchecked. When I checked it, it came back!!!

Thanks so much for your help!!!!

 

[Peter_SSs]

You're welcome. Glad you got it resolved.