Objective/usefulness: To create and apply conditional formatting following specific criteria. Proceed as follows:
- Open the Data menu | Thresholds.
- In the dropdown select Revenue | New. Create the following two conditions:
Creating and applying conditional formatting a specific criteria
To format the cells, click on the box with the 1234.12 number. This will open a format editor similar to Excel with the familiar number, alignment, font, border, and background tabs.