Manage rules in Conditional Formatting

In this article, we will learn the Conditional formatting rules manager in Microsoft Excel.

Conditional Formatting: -Conditional Formatting is used to highlight the important points with color in a report.  We are formatting the data using colors, symbols, icons, etc. based on certain conditions.

Manage Rules: - We use this rule to Create, Edit and Delete the rules for conditional formatting.

Let’s take an example to understand how you can color rows based on text criteria.

We have data in range A1:C10 in which Column A contains Student’s name, column B contains Scores and in column C is having grades. We need to highlight grades with color such as “A” grade with green color and “B” grade with blue color.

 

img1

 

To color rows based on text criteria:

  • Select the range C2:C10 by pressing the key “CTRL+SHIT+Down arrow key”.
  • Go to the “Home Tab” and then in the “Styles” group select “New Rule” from the Conditional Formatting dropdown menu.
  • The “New Formatting Rule” dialog box will appear.
  • Select the rule type “Format only cells that contain”. In the “Edit the Rule Description” select “Specific Text” from the dropdown menu.
  • In 2nd dropdown menu, select “Containing”, type “A” in the box.
  • In the dialog box below you will see the “Format” option. Click on the “Format” icon, the “Format Cells” dialog box will be active. . In the “Fill” tab, select the green color and click on OK.
  • The selected color will be displayed in the “Preview” box and then click on OK.

img2

 

  • Now select “Manage Rule” from the drop menu of “Conditional Formatting”.

img3

 

  • The “Conditional Formatting Rules Manager” dialog box will appear.

img4

 

  • Click on “New Rule”, and the “New Formatting Rule” dialog box will get activated.
  • Select a rule type “Format only cells that contain”. In the “Edit the Rule Description” box select “Specific Text” from the dropdown menu.
  • In the 2nd dropdown menu, select “Containing”, type “B” in the box.
  • In the dialog box below the “Format” option is shown. Click on the “Format” icon, the “Format Cells” dialog box will get activated. In the “Fill” tab, select the yellow color and click on OK.
  • In the “Conditional Formatting Rules Manager” dialog box, click on apply, then click on OK.

 

img5

 

 

 

img6

 

Excel

Download - Manage rules in Conditional Formatting - xlsx

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.