How to apply conditional formatting in Google Sheet

Create a conditional formatting rule

Steps to apply conditional formating

1. Select the cell range.

2. Click the format on the menu bar.

3. Select conditional formatting.

4. Under the format, there are various options: bold, italic, underline, font size, align, and others. Don’t select any of the options.

5. Since the conditional format rule appears and already the new rule has been commerce, select the conditions for the formatting to the appearance.

6. The formatting that will appear should be customized to meet the conditions.

7. Click OK and done.

The rule is already saved at this point.

The conditions and their descriptions

Under this, the user should know the needed conditions to apply the formatting appropriately. They show what the specified condition means in the formatting conditions.

Is empty

It applies formatting for empty cells.

Is not empty

It applies to the format for the cells that are not empty.

“Text contains”

It applies “formatting for cells” that have specified text.

“Text does not contain.”

It applies “formatting for cells” that don’t have a 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

It applies formatting for cells that are exactly the specified text.

Date is

It applies to formatting for cells with dates matching a specified date.

Date is before

It applies formatting for cells with dates that are before a specified date.

Date is after

It applies formatting for cells with dates that are after a specified date.

Greater than

It applies to formatting for cells with values greater than that specified value.

Greater than or equal to

It applies formatting for cells with values greater than or equal to a specified value.

Less than

It applies to formatting for cells with less than that specified value.

Less than or equal to

It applies formatting for cells with values less than or equal to a specified value.

Is equal to

It applies to the formatting for cells with values equal to that specified value.

Is not equal to

It applies formatting for cells with values not equal to that “specified value.”

“Is between”

It applies “formatting for cells” with values between two specified values.

“Is not between.”

It applies to formatting cells with values, not between two specified values.

Custom formula is

It applies formatting for cells with custom formulas.

How to delete a conditional formatting rule

If you need to delete the already set rule, check this

1. Select a cell within the conditional formatting range.

2. Under the conditional format rule, open it.

3. Click the option of the remove rule button.


The rule is deleted.

These conditions should be applied appropriately. Deleting the conditional formatting in your computer avoids confusion within the cells that are yet to be opened. If not deleted, it might cause inconvenience during other works like typesetting.

Leave a Comment