The conditional formatting feature in Excel can be used to draw attention to cells that contain specific text in in your Worksheet. Suppose, you have a range of cells and you would like to know which ones contain the letters “carpe.” Highlighting comes in very handy at this point.
Follow the steps below to learn how:
- Select your range of cells.
- With the Home tab of the Ribbon displayed, in the Styles group click Conditional Formatting . Excel will display a palette of options related to conditional formatting.
- Select New Rule to display the New Formatting Rule dialog box.
- In the Select a Rule Type area at the top of the dialog box, choose Format Only Cells that Contain.
- Using the left-most drop-down list in the criteria area, select Specific Text.
- Be certain the center drop-down list is Containing.
- In the right-hand box key in “carpe” (without quotes ).
- Click Format to display the dialog box.
- Using the controls in the dialog box, specify a format that you would like used for those cells that contain the specified text. Perhaps you may want bold text in an orange typeface.
- Click OK to close the Format Cells dialog box. The formatting you specified in step 9 should now appear in the preview area for the rule.
- Click OK.
There is a caveat to be aware of when looking for specific text and that is: The condtional formatting rule will consider the cell a match if it contains the text you specify in step 7 anywhere within the cell. So, for instance, if you use the text “carpe” in step 7, and the cell contains “My name is Carpe,” then for the purpose of this type of format, this is a match.
The reason this works this way is because you specified “Containing” in step 6. If you want some other type of match, then you will need to specify some different setting in step 6.