Time required for learning: < 2 minutes
Sometimes when managing a big spreadsheet, it can come in handy to get a better overview of the status of certain items. For instance, in migrating domain names from one host to another it may be useful to have a spreadsheet where you keep track of the status of each domain name, whether its website has been moved, if email addresses have been transferred, etc. I recently found this very helpful myself.
It turns out there’s a relatively simple way to do this in all the big Excel-type applications. This tutorial will be for Numbers since it’s what I use – Numbers is perfectly fine for amateur number-tallying.
How To Color Cells Depending On Content In Numbers
This guide assumes you have a few standard status values like Yes, No, maybe a “-” or, as in my example, “N/A” for “Not Applicable”. After following the guide you will see how easy it is to color the cells depending on any text value contained within the cell, but for now I’ll assume these are the values.
- Open your spreadsheet in Numbers for OS X.
- Select all cells you wish to color depending on their content. You can select cells by clicking and dragging. In the example above, you’d want to select cells B2-E6.
- With all the cells selected, open the Format panel (A), select the Cell tab (B), and click Conditional Highlighting… at the bottom of the pane (C).
- The panel Conditional Highlighting has opened. Click Add a Rule… (D), select Text (E), and choose is… (F). This adds a rule to match a specific word, for example “Yes”.
- Voila! Now you have a field where you can add your text/word and conditionally highlight the cell if it contains this word. In the example I simply typed “Yes” and selected “Green Fill” as the highlight from the dropdown.
- Repeat step 4 & 5 for all the rules you want to add.
Much easier to get an overview.
Did this teach you how to color cells depending on their content?