A good spreadsheet must be easy to navigate. Spreadsheets may contain hundreds, or even thousands, of entries. We don't want to get lost in numerous columns and rows when we need to find information quickly. Using color coding is one way of making spreadsheets easier to read.
Numbers has numerous tools to add colors to table grids. We can set colors for cells, columns, rows, table borders, and of course, text.
This recipe describes, first, how to set alternating colors for table rows and columns. This makes tables more reader-friendly because you are less likely to veer off the row or column you are following, this way.
Then, we will look at how to set a strong color for a row or a column that is different from other colors in the table. This can be used for an alert or a reminder concerning data in that row.
And finally, we will see how to use a clever tool that makes cells automatically change the...