Text: Is, is not, starts with, ends with, contains, and does not contain.Numbers: Equal to, not equal to, greater than, greater than or equal to, less than, less than or equal to, between, and not between.Types of Data for Conditional Highlightingīefore adding a rule for conditional highlighting, here is a list of the types of data you can use and the corresponding conditions. As you follow this tutorial, note that in Numbers, the feature is referred to as conditional highlighting, rather than conditional formatting. If you would like to set up conditional formatting in Numbers on Mac, we're here to help. When those conditions are met, you can automatically have the cell highlighted, the text formatted, or both.
You simply place conditions around the values in a cell or group of cells.
Conditional formatting in spreadsheets is a terrific feature that makes your data stand out.
