Forum Discussion
Column not matching table style
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?
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())