How to apply conditional formatting in row
In excel conditional formula can be used to highlight the specific condition. In this article we will learn how to color rows based on text criteria, we use the option of “Conditional Formatting”.
This option is available in the “Home Tab” in the Styles group in Microsoft Excel 2010.
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.
Let’s take an example to understand how you can conditional formatting row based on text criteria.
We have data in range A1:A10. Column C contains the grades. Now in column C we want to highlight the text with color. “A” grade should be highlighted with green color and “B” grade with blue color.
To color rows based on text criteria:
- Select the range C2:C10 by pressing the key “CTRL+SHIFT+Down arrow key”.
- Go to the “Home Tab” and then in the “Styles” group select “New Rule” from the Conditional Formatting drop down 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 drop down menu.
- In 2nd drop 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. . Inthe “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.
- Now select “Manage Rule” from the “Conditional Formatting” drop down menu.
- The “Conditional Formatting Rules Manager” dialog box will appear.
- Click on “New Rule”, 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 drop down menu.
- In the 2nd drop down 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.
The output is shown below -
This is the way you can put conditional format based on color for specific text.
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at firstname.lastname@example.org