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.
- Select one or more cells.
- In the Format sidebar, click the Cell tab.
- Click Conditional Highlighting, then click Add a Rule.
- Click a type of rule (for example, if your cell value will be a number, select Numbers), then click a rule.