# How to highlight cells in Numbers on Mac with conditional rules, step by step

> Learn how to highlight cells in Numbers on Mac with conditional rules. Select cells, add a rule, pick a color, then fix common problems.

URL: https://www.lazur.app/how-to/highlight-cells-with-conditional-rules-in-numbers
Updated: 2026-11-06

To highlight cells in Numbers on Mac, select the cells, open the Cell tab in the Format sidebar, click Conditional Highlighting, then click Add a Rule. Set the values, pick a text style or cell fill, and click Done to apply the highlight to every cell that matches.

## Quick answer

- Select the cells, then open the Cell tab in the Format sidebar.
- Click Conditional Highlighting, then Add a Rule, and set the values.
- Pick a text style or cell fill, then click Done.
- When two rules match one cell, the first rule in the list wins. Drag rules to reorder them.
- Edit rules in the Numbers app on your Mac. On iCloud.com you can only view them.

Applies to: Numbers for Mac on macOS, as of November 2026. Time: 6 min. Difficulty: Easy.

## What you need

- Numbers for Mac from the Mac App Store
- macOS 26.0 or later, per the current App Store listing
- Cells that hold text, dates, durations, or numbers
- A Mac to edit rules, since iCloud.com only shows them

## How to Highlight cells in Numbers on Mac with conditional rules in Numbers on a Mac

1. **Select the cells you want to highlight.** Drag across the cells that should change color. You can select one cell or a range. Leave out the header row, so its look stays the same.
2. **Open the Format sidebar.** (Format) If the sidebar is hidden, click the Format button in the toolbar. The sidebar sits on the right side of the window. It changes its tabs depending on what you select. Tip: Select cells before you open the sidebar, so the Cell tab appears.
3. **Open the Cell tab.** (Format sidebar > Cell tab) At the top of the Format sidebar, click the Cell tab. Apple's guide uses this tab for conditional highlighting.
4. **Click Conditional Highlighting.** (Cell tab > Conditional Highlighting) In the Cell tab, click Conditional Highlighting. This opens the list of rules for the selected cells.
5. **Add a rule and choose its type.** (Conditional Highlighting > Add a Rule) Click Add a Rule. Choose a rule type, such as Numbers. Numbers offers different rules for text, dates, durations, and numbers, so the list depends on what the cells hold. Then pick a specific rule.
6. **Enter the values to test.** Type the value the rule should check. To compare against another cell, click the Cell Reference button, then click the cell. The rule tests that cell's contents. Tip: If the rule should hold its reference as it copies down a column, use Preserve Row or Preserve Column.
7. **Choose a text style or cell fill.** Pick a text style or a cell fill for matching cells. For a custom font color, font style, and cell fill together, choose Custom Style. The look applies when a cell matches the rule.
8. **Click Done and check the result.** Click Done. Look at a few cells that should match and a few that should not. A wrong match usually means the values or the reference need a change. Tip: Keep one row you know should not match, so you can confirm the rule stays quiet.
9. **Reorder rules if two rules match.** (Cell tab > Show Highlighting Rules) If a cell matches more than one rule, the first rule in the list wins. Open Show Highlighting Rules, then drag a rule name up or down the list to change the order.
10. **Copy a rule with Combine Rules.** (Cell tab > Show Highlighting Rules > Combine Rules) Select the cell that holds the rule and the target cells. In the Cell tab, click Show Highlighting Rules, then click Combine Rules. The target cells take on the rule.
11. **Clear rules to start over.** (Advanced Options > Clear All Rules) Select the cells, open Advanced Options at the bottom of the sidebar, then choose Clear All Rules. To remove one rule only, hover over it and click its Trash button. Tip: Clear All Rules works on the selected cells only. Other highlights stay as they are.

## What conditional highlighting does in Numbers

Conditional highlighting changes how a cell looks when its contents meet a condition you set. The value stays the same. Only the look changes. A due date that has passed can turn red, and a status cell that says Late can get a fill color. You do not have to recolor cells by hand each time the data changes.

![Person at a desk learning how to highlight cells in Numbers on Mac on a laptop](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/howto/highlight-cells-with-conditional-rules-in-numbers/how-to-highlight-cells-in-numbers-on-1-21bac6.jpg)

On a Mac, the controls live in the Format sidebar on the right side of the window. MacMost writes the path as Format > Cell > Conditional Highlighting. Apple's guide describes the same place as the Cell tab in the Format sidebar. The wording differs, but the place is the same.

Apple's guide is dated 9/9/22, according to MacMost. MacMost warns that menu names can differ in other versions, so match the labels on your screen against the steps here. If a label has changed, look for the same word in the sidebar.

## Check your Numbers and macOS versions first

The App Store listing for Numbers shows version 15.4.2 and says it requires macOS 26.0 or later. Wikipedia lists the release as 15.4 and says it requires macOS 15.6 or later. The two sources disagree. The App Store listing names a newer release, so check it first.

> **Version conflict:** Sources disagree on the minimum macOS for Numbers. Open the App Store, search for Numbers, and read the requirement before you update. If your Mac runs an older macOS, the menus may look different.

To find your macOS version, choose Apple menu > About This Mac. Compare that with the requirement in the App Store listing. If your Mac is too old for the current Numbers, the steps here may not match what you see on screen.

## A worked example: flag overdue dates in a project table

Say column A holds task names and column B holds due dates. You want any overdue task to show in red, so you can scan the list in a second. The rule goes on the due-date cells only, not on the header row or the task names.

Select the due-date cells by dragging across them. Open the Cell tab, click Conditional Highlighting, and click Add a Rule. Choose the date rule type. Rule names vary by what the cells hold, so read each option before you pick one. Choose a red text style or a red cell fill, then click Done.

Check the result on a few rows. An overdue date should be red. A date in the future should stay plain. If future dates turn red too, the rule compares the wrong way. Open Show Highlighting Rules and edit it.

![Close up of a spreadsheet on a screen with rows of data ready for review](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/howto/highlight-cells-with-conditional-rules-in-numbers/how-to-highlight-cells-in-numbers-on-3-7b5031.jpg)

## Rule order decides which color wins

A cell can match more than one rule. Numbers applies the first rule in the list, and the cell takes that rule's look. Later rules do not change it. This is the most common reason a highlight looks wrong, so check the order first.

Open Show Highlighting Rules and drag a rule name up or down the list. Put the most urgent rule at the top. In the example, put overdue in red above a rule for due soon in yellow. Then a task that is both overdue and due soon shows red.

## Copy a rule to other cells with Combine Rules

Once a rule works on one cell, you can spread it. Select the cell that holds the rule and the target cells. In the Cell tab, click Show Highlighting Rules, then click Combine Rules. The target cells pick up the rule.

Combine Rules also helps when a rule applies to only part of a range. If only some cells change color, select the full range and combine again. Then check the first and last cells of the range.

## Compare a cell to another cell

The Cell Reference button lets a rule compare against another cell instead of a typed value. Click it, then click the cell to compare. The rule then tests against that cell's contents.

Relative references shift as the rule moves. MacMost says a reference shifts row by row, so only the first cell may match. To hold the reference in place, use Preserve Row or Preserve Column. This fixes most cases where only the top cell lights up.

> **Preserve the reference:** If only the first row matches, the reference is moving down. Preserve Row or Preserve Column keeps it fixed in place.

Some comparisons need more than one cell. MacMost describes a helper column with an IF or OR formula. A text rule then compares against the adjacent cell. You can hide the helper column when you finish. For formula basics, read [how to add a formula to a cell in Numbers](https://www.lazur.app/how-to/add-a-formula-to-a-cell-in-numbers).

## Remove a rule or clear every rule in a selection

| Goal | Where to click | What it changes |
| --- | --- | --- |
| Clear all rules on the selected cells | Advanced Options > Clear All Rules | Only the cells you selected |
| Delete one rule | Hover over the rule, then click its Trash button | Only that rule |
| Remove a rule from every cell that uses it | Advanced Options > Select Cells with Matching Rules, then Trash | Every cell that uses the rule |

_Three ways to remove highlighting rules in Numbers on Mac._

Advanced Options sits at the bottom of the sidebar. Clear All Rules works on the cells you selected, so select only what you want to change. Numbers' guide lists no keyboard shortcut for this feature, so you use the sidebar. Undo with ⌘Z if you clear the wrong cells.

> **Clear All Rules is immediate:** Clear All Rules removes every rule on the selected cells at once. Select only the cells you mean to change before you choose it.

## Mistakes people make with highlighting in Numbers

The first mistake is including the header row. A text rule can match a header by accident, and then the header changes color. Select the data cells only, and leave the header as it is.

The second mistake is adding rows and expecting the color to follow. Check that new rows fall inside the range the rule covers. If they do not, use Combine Rules to copy the rule to them.

The third mistake is trusting a rule you have not tested. Raymond Panko's paper Spreadsheet Errors: What We Know. What We Think We Can Do says fifteen years of research concluded unanimously that spreadsheet errors are both common and non-trivial. Test a few known cells before you rely on a highlight.

- **15 years** of research that Raymond Panko says found spreadsheet errors are common and non-trivial ([source](https://arxiv.org/abs/0802.3457))

Keep a small key for your colors, either in a note or in a cell above the table. Write down what red and yellow mean. Anyone who opens the file can then read the highlights without guessing.

## Highlighting versus filtering in Numbers

Use a highlight when you want to see every row and spot the odd ones out. Use a filter when you want only the matching rows on screen. A highlight keeps the surrounding rows visible, which helps when the neighbors give context.

## Editing highlights on iCloud.com

Apple's list of features for Numbers on iCloud.com says you can view but not edit conditional highlighting rules. A highlight you set on the Mac can still show on iCloud.com, but you cannot change its rules there. Make edits in the Numbers app on your Mac.

## Older reports about date rules

An Apple Community thread about Numbers 5.3 on OS X 10.14.3 describes a date rule. A rule set to days from now displayed as days ago after clicking Done and reopening Show Highlighting Rules. Users saw a display bug, but the rule still highlighted correctly.

![Man using a Mac computer to review a spreadsheet table with colored rows](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/howto/highlight-cells-with-conditional-rules-in-numbers/how-to-highlight-cells-in-numbers-on-2-bd032b.jpg)

The same thread gives a workaround. The rule in the next 4 days displays correctly, but it ignores dates before today. The thread is closed with no official fix listed, so test date rules on known dates before you trust them.

## Where to go next

Highlighting pairs well with sorting. Read [how to sort a table in Numbers on Mac by column](https://www.lazur.app/how-to/sort-a-table-by-column-in-numbers) or [how to filter a table in Numbers on Mac](https://www.lazur.app/how-to/filter-table-rows-in-numbers) to bring flagged rows together.

If you still need a table, [how to add a table in Numbers on Mac](https://www.lazur.app/how-to/add-a-table-in-numbers) covers the Table button and styles. For the app itself, see the [Numbers page](https://www.lazur.app/apps/numbers).

## If it does not work

- **Only the first cell highlights when I expect the whole column.** The reference shifts row by row, so only the first cell may match. Add Preserve Row or Preserve Column to the reference, then check several rows.
- **A cell shows the wrong color even though the rule looks right.** Another rule higher in the list is matching first. Open Show Highlighting Rules and drag the rule you want to the top.
- **Only some of the selected cells change color.** The rule covers part of the range. Select the full range, then use Combine Rules to apply the rule to all the target cells.
- **Comparing one column to another column does not work.** Add a helper column with an IF or OR formula. The text rule then compares against the adjacent cell. Hide the helper column when you finish.
- **On iCloud.com I cannot change a highlight.** iCloud.com shows highlighting rules but does not let you edit them. Open the file in Numbers on your Mac and change the rule there.
- **A date rule reads days ago after I click Done.** This display bug was reported in Numbers 5.3 on OS X 10.14.3, and the rule still highlights. Test it on known dates and report it through Numbers' feedback option.

## With Lazur

Lazur is a voice assistant for the Mac that lives in the notch. Hold ⌥ ⌘ and ask; it sees your screen, answers out loud, points at buttons and walks you through apps. Hold fn to dictate. Free for 3 days, then $18/month: https://www.lazur.app/download

- “Where's the Conditional Highlighting button?”: Lazur draws a circle and a label around Conditional Highlighting in the Format sidebar. You make the click yourself. (Points at it)

## FAQ

### Can I highlight a whole row based on one cell?

Select the whole row, then add the rule. Each cell tests its own contents, so the rule checks every cell in the row separately. Check several rows afterward. If only the first row changes, fix the reference with Preserve Row or Preserve Column.

### How do I remove highlighting from only one cell?

Select that cell, open the Cell tab, then open Advanced Options and choose Clear All Rules. Clear All Rules affects only the selected cells, so highlights on other cells stay as they are.

### Which rule wins when two rules match the same cell?

The first rule in the list wins. Open Show Highlighting Rules and drag rule names to reorder them. The cell takes the look of the top matching rule, and lower rules do not change it.

### Can I highlight a cell based on another cell?

Yes. Use the Cell Reference button to compare against another cell in a rule. For a comparison across two columns, MacMost describes a helper column with an IF or OR formula, and a text rule checks the adjacent cell.

### Can I edit highlight rules on iCloud.com?

No. Apple lists conditional highlighting rules as view-only on iCloud.com, so you can see them there but not change them. Make your edits in Numbers on your Mac.

### Is there a keyboard shortcut for conditional highlighting?

Not in Apple's guide, and none turned up in the other sources checked for this page. Use the Format sidebar with the mouse or trackpad. Undo with ⌘Z works as it does in most Mac apps.

### What macOS do I need for Numbers today?

The App Store listing for Numbers 15.4.2 says macOS 26.0 or later. Wikipedia says the 15.4 release needs macOS 15.6. Use the App Store listing, since it names the newer release.

## Sources

1. [Use cell conditions in Numbers on Mac: Apple Support Guide](https://support.apple.com/guide/numbers/highlight-cells-tan93f5de5c3/mac), Apple, checked 2026-11-07
2. [Features in Pages, Numbers and Keynote on iCloud.com: Apple Support](https://support.apple.com/en-my/105051), Apple, checked 2026-11-07
3. [Numbers on the Mac App Store](https://apps.apple.com/us/app/numbers/id361304891?mt=12), Apple, checked 2026-11-07
4. [Mac Numbers Conditional Highlighting and Alternatives: MacMost](https://macmost.com/mac-numbers-conditional-highlighting-and-alternatives.html), MacMost, checked 2026-11-07
5. [Conditional highlighting not working: Apple Community](https://discussions.apple.com/thread/250225879), Apple Community, checked 2026-11-07
6. [Numbers (spreadsheet): Wikipedia](https://en.wikipedia.org/wiki/Numbers_(spreadsheet)), Wikipedia, checked 2026-11-07
7. [Spreadsheet Errors: What We Know. What We Think We Can Do (arXiv)](https://arxiv.org/abs/0802.3457), arXiv, checked 2026-11-07