To highlight numbers that meet a condition on a Mac, select the cells in your spreadsheet, open the app’s conditional formatting controls, choose a numeric rule, set its threshold and appearance, then apply it. In Excel for Mac, use Home > Conditional Formatting > Highlight Cells Rules; in Numbers, use Format > Cell > Conditional Highlighting. The steps below cover both apps because their controls have different names.

Choose a rule that matches what you need

Start with the cells that contain the numbers you want to check. For a simple cutoff, use a greater-than, less-than, equal-to, or between rule. For example, to flag scores below 60, select the score range and choose a less-than rule with 60 as the threshold. For values in a band, choose between and enter both endpoints. In Excel for Mac, Microsoft documents number examples such as values between 50 and 100 under Highlight Cells Rules. In Numbers, choose the Numbers rule type and then the comparison rule that fits your condition. Microsoft’s Excel for Mac instructions and Apple’s Numbers guide describe these app-specific controls.

If you want to see relative size rather than flag a fixed threshold, consider a color scale or data bar in Excel. A color scale shades cells according to their value’s position in the selected range; data bars show a bar inside each cell, with longer bars for larger values. Use these when comparing a set of numbers. A fixed rule is clearer when a particular limit matters, such as scores under 60. Microsoft explains these Excel formats and their purpose.

In Excel for Mac: apply a numeric rule

  1. Select the range of numeric cells. Keep the selection to the values you want evaluated; including headers or unrelated columns can make the result confusing.
  2. On the Home tab, select Conditional Formatting.
  3. Point to Highlight Cells Rules, then choose the needed comparison, such as Greater Than, Less Than, Between, or Equal To.
  4. Enter the threshold or thresholds, choose a formatting style, and confirm the rule. The selected cells will change appearance when their values meet the condition.

For example, to shade inventory quantities below 10, select the quantity cells, choose Less Than, enter 10, and select a fill style. This flags the values as they change, unlike a one-time manual fill. Excel also offers Top/Bottom Rules, data bars, color scales, and icon sets from the Conditional Formatting menu; choose those only when ranking or visual comparison is the goal. Microsoft lists the Mac menu path and rule families.

In Numbers for Mac: add conditional highlighting

  1. Select one or more cells in the table.
  2. In the Format sidebar, click Cell.
  3. Click Conditional Highlighting, then Add a Rule.
  4. Choose Numbers, select the comparison rule, and enter the required value or values.
  5. Choose a text style or cell fill from the pop-up menu, then click Done.

Numbers can also compare a cell with a reference cell: use the cell-reference control in the rule and select or enter the other cell’s address. This is useful when a threshold is stored in the sheet and may change. Apple notes that if a cell matches multiple rules, its appearance follows the first rule in the list; drag rules to change their order. Apple documents numeric rules, cell references, styles, and rule order.

Extend, check, or remove a rule

In Excel, use Conditional Formatting > Manage Rules to select and edit a rule, or delete it. To remove formatting from a selection, choose Conditional Formatting > Clear Rules and the appropriate clearing option. Be careful with Edit > Clear > Formats: Microsoft says it removes all cell formatting as well as conditional formats for the selected cells. Microsoft’s Mac instructions cover editing, deleting, and clearing rules.

In Numbers, select the cell with a rule and the cells that should receive it, then open Format > Cell > Show Highlighting Rules > Combine Rules. To remove rules, show the highlighting rules and delete a specific rule with its trash button, or use Clear All Rules for the selected cells. Apple’s Numbers guide describes repeating and deleting highlighting rules.

If a rule appears to do nothing, first confirm that the selected cells contain numeric values and that the threshold matches the underlying value. A displayed value may be rounded or formatted as currency while the stored number has more decimal places; conditional formatting evaluates the cell value rather than the way it is displayed. This is a practical diagnostic inference from rules being based on cell values, as documented by Apple and Microsoft. If the outcome is still unexpected, inspect the selected range and rule thresholds before adding another rule.

Sources