How to Edit Conditional Formatting in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on June 25, 2022

This tutorial demonstrates how to edit conditional formatting in Excel and Google Sheets.


conditional formatting edit 5


Edit Conditional Formatting Rules in Excel

Using Rule Manager, you can easily change the hierarchy of conditional formatting rules, delete them, or make new ones.

  1. Select the data range (e.g., C1:C6).
  2. In the Ribbon, go to Home > Conditional Formatting > Manage Rules…


conditional formatting edit 1


  1. In the Conditional Formatting Rules Manager window, select the rule you want to edit and click Edit Rule.


conditional formatting edit 2


  1. 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.


conditional formatting edit 6


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.


conditional formatting edit 7


Edit Conditional Formatting Rules in Google Sheets

In Google Sheets, you can edit an existing rule or simply update the format.

  1. First, select the formatted range (e.g., A1:C5).
  2. In the Menu, go to Format > Conditional Formatting.


conditional formatting edit 8


  1. The Conditional format rules pane opens on the right side of the sheet. In it, double-click on the rule you want to edit.


conditional formatting edit 10


  1. Now, edit the rule and click Done.


conditional formatting edit 11

AI Formula Generator

Try for Free

See all How-To Articles