This tutorial demonstrates how to edit conditional formatting in Excel and Google Sheets.
Edit Conditional Formatting Rules in Excel
- Select the data range (e.g., C1:C6).
- In the Ribbon, go to Home > Conditional Formatting > Manage Rules…
- In the Conditional Formatting Rules Manager window, select the rule you want to edit and click Edit Rule.
- This opens the Edit Formatting Rule window. In it, you can choose a new rule type for a selected range or edit the existing rule.
For more information on conditional formatting settings and options you can use to make your changes, see Conditional Formatting **Tips for 2022**.
Note: To delete a rule, just select it and click the Delete Rule button.
Edit Conditional Formatting Rules in Google Sheets
In Google Sheets, you can edit an existing rule or simply update the format.
- First, select the formatted range (e.g., A1:C5).
- In the Menu, go to Format > Conditional Formatting.
- The Conditional format rules pane opens on the right side of the sheet. In it, double-click on the rule you want to edit.
- Now, edit the rule and click Done.