Google Sheets Conditional Formatting

How to Apply Conditional Formatting in Google Sheets

Google Sheets Training

Google Sheets Training Features:

  • Interactive bite-sized lessons

  • Get Certified

  • Accurate skill assessments

  • Customizable, LMS-ready content

Prices
Users love us
4.9 stars out of 5 on G2

4.9 out of 5 on G2

Google Sheets Conditional Formatting

You can apply certain formatting to cells that meet criteria that you set. This is called conditional formatting.

Create a Conditional Formatting Rule

  1. Select a cell range.
  2. Click Format on the menu bar.
  3. Select Conditional formatting.
    How to create a Conditional formatting rule in Google Sheets.

    The Conditional format rules pane appears, and a new rule has been started.

  4. Select the conditions for the formatting to appear.
  5. Customize the formatting that will appear when the conditions are met.
  6. Click Done.
    How to create a Conditional formatting rule in Google Sheets.

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

  1. Select a cell within the conditional formatting range.
  2. With the Conditional Format Rules pane open, click the Remove rule button.
    How to delete a Conditional formatting rule in Google Sheets.

The rule is deleted.