If you use conditional formatting in Microsoft Excel, then you most likely understand you can make use of more than one guideline each time. To manage those rules in addition to edit, erase, or replicate one, you can make use of the Rules Manager.

Whether you’re highlighting a row or seeking replicate information, you can apply multiple conditional format rules to the very same collection of cells or various cells in the exact same spread sheet. Plus, you could set up rules in numerous sheets in your workbook. With the Rules Manager, you have a simple way to check out and take care of every one of your format policies.

Open the Rules Manager in ExcelManage Conditional Formatting Rules Create a New Rule Edit a Rule Delete a Rule Duplicate a Rule Rearrange Your Rules

Open Up the Rules Manager in Excel

Before opening the Rules Manager, you can select a particular sheet to deal with if you like. Nonetheless, the tool allows you choose the spreadsheet having the conditional format guidelines you want to take care of.

Most likely to the Home tab, click the Conditional Formatting drop-down arrowhead, and also pick “Manage Rules.”

When the Conditional Formatting Rules Manager window shows up, make use of the drop-down box on top to pick the sheet or to utilize the existing option of cells and watch the regulations.

This permits you to jump between the rules you set up for different spread sheets in your workbook.

Manage Conditional Formatting Rules

Across the top of the Rules Manager are numerous activities you can take. After you take an activity, click “Apply” and after that “OK” at the bottom of the device. As well as naturally, if you alter your mind, click “Cancel.”

Click “New Rule” to set up one more in the present sheet or for your selected cells. If you don’t have actually cells chosen currently, you’ll just require to include them in the “Applies To” column for that policy.

Click “Edit Rule” to alter the regulation type and description. This box looks comparable to the New Rule window. You can make modifications to the rule or the formatting itself. When you finish, click “OK” to use the changes.

If you just want to transform the variety of cells for a guideline, just upgrade the cell referrals in the Applies To column for that rule.

If you intend to remove a rule completely, click “Delete Rule.” Just be aware that you will not be asked to verify this activity. So, when you erase a conditional formatting policy right here, it’s eliminated forever.

A very easy means to set up a similar conditional format rule is by duplicating a present one. Perhaps you developed a regulation based upon date to ensure that all days recently are highlighted in eco-friendly. However you also desire a rule so that dates this week are highlighted in yellow. You can click “Duplicate Rule” for the initial one, then click “Edit Rule” for the copied one and also make your modifications.

This is likewise useful if you wish to use the exact same regulation to one more cell array.

The guidelines detailed in the tool are in the order that they use. This implies if you have greater than one regulation for the same collection of cells, each policy uses in the order it’s revealed. You can reorganize this order making use of the arrowhead buttons on the appropriate side.

Select a policy you want to move up or down and also make use of the equivalent arrow to move it.

Along with reordering your guidelines, you might wish to quit those in the checklist from being applied at some time. For this situation, you would examine package on the right of the policy for “Stop If True.” Then, if the regulation uses as well as conditional formatting takes place, no additional guidelines will be used.

Below’s an instance: Say you’re highlighting values based on position. You have rules to highlight cells with numbers above typical and also those in the leading 50 percent. However those above average are your main concern. You can inspect package for Stop If True to make sure that if the above average regulation applies to those cells, it will certainly quit there and not highlight those in the leading 50 percent as well.

You can keep track of your conditional formatting rules conveniently with the Rules Manager in Excel. And also for additional policies that could interest you, take a look at how to make use of symbol sets to stand for values or exactly how to highlight blanks or cells with errors.