Column not matching table style

%3CLINGO-SUB%20id%3D%22lingo-sub-2094478%22%20slang%3D%22en-US%22%3EColumn%20not%20matching%20table%20style%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2094478%22%20slang%3D%22en-US%22%3EHi%2C%20I%E2%80%99ve%20just%20created%20a%20table%20and%20one%20column%20hasn%E2%80%99t%20change%20to%20the%20banded%20colours.%20I%E2%80%99ve%20checked%20that%20it%20has%20%E2%80%9Cno%20fill%E2%80%9D.%20It%20does%20have%20conditional%20formatting%2C%20would%20that%20affect%20it%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2094478%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2094631%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20not%20matching%20table%20style%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2094631%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F941964%22%20target%3D%22_blank%22%3E%40EWright410%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYes%2C%20conditional%20formatting%20will%20be%20on%20the%20top%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2094638%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20not%20matching%20table%20style%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2094638%22%20slang%3D%22en-US%22%3EHi%20Sergei%2C%20is%20there%20a%20way%20to%20make%20it%20not%20on%20the%20top%20so%20it%20matches%20the%20rest%20of%20the%20table%20style%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2094652%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20not%20matching%20table%20style%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2094652%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F941964%22%20target%3D%22_blank%22%3E%40EWright410%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESorry%2C%20I%20don't%20know%20about%20such%20option%2C%20maybe%20with%20VBA%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
Hi, I’ve just created a table and one column hasn’t change to the banded colours. I’ve checked that it has “no fill”. It does have conditional formatting, would that affect it?
4 Replies

@EWright410 

Yes, conditional formatting will be on the top

Hi Sergei, is there a way to make it not on the top so it matches the rest of the table style?

@EWright410 

Sorry, I don't know about such option, maybe with VBA

@EWright410 

I am the wrong person to be contributing to this discussion since the immediate actions following the creation of a new table are a) Select White Table Style Light 1 b) Cancel Filter button c) Cancel banded rows d) View Cancel gridlines.  Not exactly in the spirit of spreadsheets!

 

Since you clearly like stripes, a couple of observations.

Firstly the the stripes still show for cells that do not satisfy the CF.  Secondly formula-driven conditional formats can reproduce an alternating pattern, e.g.

=(H5<>"") * ISEVEN(ROW())

=(H5<>"") * ISODD(ROW())