How can I match the alternating colors in my Numbers spreadsheet in the Header Columns? It's so weird that the body has alternating colors and the Header Column does not. It must be sortable without the colors getting all out of order, as well. Please help.
iMac 24″, macOS 13.3
That's just how they designed it. You can make a header column alternate in color if you make an extra column of formulas (which you will hide later) and set up a conditional highlighting rule for the header column based on the results of those formulas. Or don't use a header column at all.
The formula in new column B is
=IF(ISEVEN(ROW()),A&"1",A&"")
The highlighting rule for cell A2 is "text is same as cell B2". You can do the entire column at once if you select all the cells (A2 to the bottom) then set up the rule for A2.
DrCry555 wrote:
Header Column does not. It must be sortable without the colors getting all out of order, as well.
You can sort by row but not by column. Perhaps you mean you want to display alternating colors in your Header Rows (of which you can have up to 5). Since you can have at most 5, why not just set their colors manually>
SG
Alternating Colors in Header Columns?
