Highlight Cells Containing Specific Text with Conditional Formatting

During working on large worksheet you must need to highlight few cells on particular text and this could be done with Conditional formatting. In this article we have to discuss how to highlight cells containing specific text with Conditional formatting.

Conditional Formatting is an important tool of Microsoft Excel. Conditional formatting allows you to quickly apply the formatting on particulars cell or range of cell contents. There are lot of options you have to use when you want to apply conditional formatting on selected range of cells. You can apply conditional formatting on particular text, numbers, date or apply any function on selected range of cells. You can also edit or remove the apply conditional formatting on selected range of cells or entire worksheet.

Highlight Cells Containing Specific Text with Conditional Formatting

During working on the spreadsheet you have to quickly highlight the important information to take your attention. There is few built in formatting rules which you have to apply as per your need. You can also create your own rules with the help of function to apply conditional formatting on active worksheet.

For eg: If you want to highlight all those cells in which you have only those books name which match with the “Tally”. In that situation you have to use Conditional formatting feature on active worksheet.

Step 1: Select the range of cells in which you want to highlight cells containing specific text with Conditional formatting.

Step 2: Click on the Home > Conditional Formatting > New Rule… option. In the Rule Type box choose “Format only cells that contain” option.

Step 3: Choose Specific Text option and type the text name which you want to highlight with the help of conditional formatting.

Step 4: Click on the Format button and fill the required color, border, font as per your need and click on the OK button. Again click on the OK button to highlight cells containing specific text with conditional formatting in active worksheet.

Step 3: Type the specific text which you want to highlight and set the required formatting as per your requirement. Now, click on the OK button to highlight cells containing specific text with Conditional formatting.

I hope after reading this guide you can easily highlight cells containing specific text with Conditional formatting. We just share want to share our knowledge with all those guys who relay want to do few important things. If you have any query or suggestion regarding this guide then please write us in the comment box. Thanks to all.