How-to · Numbers for Mac
How to highlight cells in Numbers on Mac with conditional rules, step by step
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.
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
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.
Open the Format sidebar
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.
Open the Cell tab
At the top of the Format sidebar, click the Cell tab. Apple's guide uses this tab for conditional highlighting.
Click Conditional Highlighting
In the Cell tab, click Conditional Highlighting. This opens the list of rules for the selected cells.
Add a rule and choose its type
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.
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.
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.
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.
Reorder rules if two rules match
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.
Copy a rule with 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.
Clear rules to start over
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.
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.
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.
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.
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.
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 |
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.
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
Spreadsheet Errors: What We Know. What We Think We Can Do (arXiv)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.
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 or how to filter a table in Numbers on Mac to bring flagged rows together.
If you still need a table, how to add a table in Numbers on Mac covers the Table button and styles. For the app itself, see the Numbers page.
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.
Faster with Lazur
Do it faster: ask Lazur while you are in Numbers
Hold ⌥ ⌘ and say what you want. Lazur sees your Numbers window. Lazur draws a circle and a label around the button or menu you need.
- 1
Hold ⌥⌘ and talk
- 2
Lazur draws a circle and a label around the button or menu you need.
- 3
You stay in Numbers. Nothing to copy into a chat window.
Free for 3 days, then $18/month. Download for Mac
You say“Where's the Conditional Highlighting button?”
Lazur · points at itLazur draws a circle and a label around Conditional Highlighting in the Format sidebar. You make the click yourself.
Questions people ask
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
- Use cell conditions in Numbers on Mac: Apple Support Guide · Apple · checked 2026-11-07
- Features in Pages, Numbers and Keynote on iCloud.com: Apple Support · Apple · checked 2026-11-07
- Numbers on the Mac App Store · Apple · checked 2026-11-07
- Mac Numbers Conditional Highlighting and Alternatives: MacMost · MacMost · checked 2026-11-07
- Conditional highlighting not working: Apple Community · Apple Community · checked 2026-11-07
- Numbers (spreadsheet): Wikipedia · Wikipedia · checked 2026-11-07
- Spreadsheet Errors: What We Know. What We Think We Can Do (arXiv) · arXiv · checked 2026-11-07
Try Lazur free for 3 days
Hold a key and ask. Lazur sees your screen, points at the button and talks you through it, in any Mac app. No credit card.