Sharing is caring!

Conditional formatting in spreadsheets is a terrific feature that makes your data stand out. You simply place conditions around the values in a cell or group of cells. When those conditions are met, you can automatically have the cell highlighted, the text formatted, or both. This makes specific data pop.

Numbers for Mac: Add conditional highlighting to cells in a Numbersspreadsheet
  1. Select one or more cells.
  2. In the Format sidebar, click the Cell tab.
  3. Click Conditional Highlighting, then click Add a Rule.
  4. Click a type of rule (for example, if your cell value will be a number, select Numbers), then click a rule.
READ  How to Run Chrome OS From a USB Drive