
You can apply certain formatting to cells that meet criteria that you set. This is called conditional formatting.
Create a Conditional Formatting Rule
- Select a cell range.
- Click Format on the menu bar.
- Select Conditional formatting.
The Conditional format rules pane appears, and a new rule has been started.
- Select the conditions for the formatting to appear.
- Customize the formatting that will appear when the conditions are met.
- Click Done.
The rule is saved.
Condition | Description |
---|---|
Is empty | Applies formatting for empty cells. |
Is not empty | Applies formatting for cells that aren't empty. |
Text contains | Applies formatting for cells that contain specified text. |
Text does not contain | Applies formatting for cells that do not contain specified text. |
Text starts with | Applies formatting for cells that start with specified text. |
Text ends with | Applies formatting for cells that end with specified text. |
Text is exactly | Applies formatting for cells that exactly match the specified text. |
Date is | Applies formatting for cells with dates that match a specified date. |
Date is before | Applies formatting for cells with dates that are before a specified date. |
Date is after | Applies formatting for cells with dates that are after a specified date. |
Greater than | Applies formatting for cells with values that are greater than a specified value. |
Greater than or equal to | Applies formatting for cells with values that are greater or equal to a specified value. |
Less than | Applies formatting for cells with values that are less than a specified value. |
Less than or equal to | Applies formatting for cells with values that are less than or equal to a specified value. |
Is equal to | Applies formatting for cells with values that are equal to a specified value. |
Is not equal to | Applies formatting for cells with values that are not equal to a specified value. |
Is between | Applies formatting for cells with values that are between two specified values. |
Is not between | Applies formatting for cells with values that are not between two specified values. |
Custom formula is | Applies formatting for cells with custom formulas. |
Delete a Conditional Formatting Rule
- Select a cell within the conditional formatting range.
- With the Conditional Format Rules pane open, click the Remove rule button.
The rule is deleted.
FREE Quick Reference
Click to DownloadFree to distribute with our compliments; we hope you will consider our paid training.