How To View Conditional Formatting Rules In Google Sheets

Google Sheets is a resourceful tool that offers a wide array of functionalities. Among these, the feature of conditional formatting stands as one of the most useful. Conditional formatting allows you to automatically apply formatting, such as colors and icons, to a range of cells if they meet specified conditions. This blog post will guide you on how to view these conditional formatting rules in Google Sheets.

Step 1:

To start with, open your Google Sheets document. Once you’ve done that, you’ll want to select the range of cells where you’ve applied conditional formatting. If you’re not sure where you’ve applied the formatting, simply click on any cell.

Step 2:

Secondly, navigate to the toolbar at the top of the page. Click on the Format option, and then select Conditional formatting from the dropdown menu.

Step 3:

In the sidebar that appears, you will see the conditional formatting rules applied to the selected cell. If there are multiple rules applied to the same cell, they will be listed in the order they are applied. Remember that rules at the top of the list are applied first and might override rules below.

The conditional formatting rules window provides you with a clear snapshot of the rules in place. You can see:

  • Range: The cell or range of cells the rule applies to.
  • Format cells if: This displays the condition that triggers the rule.
  • Formatting style: This shows how the cells will be formatted when the condition is met.

Step 4:

If you want to view the rules for a different cell or range of cells, simply click on that cell or select the range. The conditional formatting rules for that selection will display in the sidebar.

Deleting a Rule:

Moreover, if you wish to delete a rule, just click on the trash bin icon to the right of the rule in the sidebar. Remember, when you delete a rule it will be removed immediately. There is no need to save your changes.


And there you have it! Viewing conditional formatting rules in Google Sheets is easy and straightforward. By following these steps, you can easily manage and understand the rules applied to your spreadsheet. Happy spreadsheeting!