Color-coded shortlist
Learn how a color-coded shortlist works: set a color key legend, tag priority and status, and compare listings side by side in one spreadsheet.
Contents
- Set a legend before coloring
- Separate priority tags from status colors
- Automate colors with conditional formatting
- Questions about color-coded shortlists
- What is a color-coded shortlist system?
- How many colors should a shortlist use?
- Should I color the whole row or just the status cell?
- Can colors replace a written note on each listing?
A color-coded shortlist is a comparison sheet where each listing carries a color from a defined key, so priority, status and fit can be read at a glance. This page explains how to build one, how to keep the colors meaningful, and how to compare listings side by side without losing the details that matter to you.
Set a legend before coloring
A color key legend turns scattered colors into a readable system for your shortlist. Write down what each color means before you mark any listing, such as one shade for a strong match and another for a rejected option. Place the legend at the top of the sheet so anyone reading the comparison can decode it. Keep the number of colors small, because a key with too many shades becomes hard to remember.
Separate priority tags from status colors
Priority tags show how much a listing matters to you, while status colors show where the listing stands in your review. Mixing the two on one cell hides information, so give priority its own column and reserve colors for status. A listing can then be a high priority and still be marked as waiting for information. Keeping the signals apart lets you filter by either one without repainting the sheet.
Automate colors with conditional formatting
Conditional formatting applies a color automatically when a cell matches a rule you set in the spreadsheet. Point a rule at a value in your status column, and spreadsheet highlighting updates the row whenever that value changes. Automation suits shortlists that you edit often, because the colors follow the data instead of your memory. Check the rules after you add rows, since a copied sheet can carry rules that no longer match your columns.
Questions about color-coded shortlists
What is a color-coded shortlist system?
A color-coded shortlist system is a fixed set of colors, rules and columns that lets you compare listings consistently. The system pairs a color key legend with status colors and priority tags so each mark has one meaning. Writing the rules down first keeps the colors useful as the list grows.
How many colors should a shortlist use?
A shortlist works with a small palette of three to five colors, each tied to one clear meaning. More shades than that force you to check the legend on every glance, which slows the comparison. Choose the distinct meanings you actually track, then discard any color without a purpose. Listing comparison colors serve the decision, not the design.
Should I color the whole row or just the status cell?
Coloring only the status cell keeps the sheet readable and preserves the other data in each row. A fully colored row can overpower the text and make two listings look alike when only one detail differs. Use a single filled cell for status and let conditional formatting handle any repeated pattern. If you need a stronger signal, add a symbol in a separate column instead of more color.
Can colors replace a written note on each listing?
Colors cannot replace a written note, because a shade shows a category but not the reason behind it. Add a short comment column beside the colors so a reader learns why a listing qualified or failed. Notes also survive when the colors are misread or a legend is lost. The combination of color and text keeps the shortlist understandable on its own.