excel for mac select cells with containing specific text

If you want some other type of match, then you'll need to pick some different setting in step 6. The reason this works this way is because you specified 'Containing' in step 6. So, for instance, if you use the text 'shawn' in step 7, and the cell contains 'My name is Shawn,' then for the purpose of this type of format, this is a match. There is a gotcha to be aware of when looking for specific text: The condtional formatting rule will consider the cell a match if it contains the text you specify in step 7 anywhere within the cell. The formatting you specified in step 9 should now appear in the preview area for the rule. Click OK to dismiss the Format Cells dialog box.For instance, you may want bold text in a red typeface. Using the controls in the dialog box, specify a format that you want used for those cells that contain the specified text.Click Format to display the Format Cells dialog box.In the right-most box enter 'shawn' (without the quote marks).Make sure the center drop-down list is Containing.Using the left-most drop-down list in the criteria area, select Specific Text.In the Select a Rule Type area at the top of the dialog box, choose Format Only Cells that Contain.Excel displays the New Formatting Rule dialog box. Excel displays a palette of options related to conditional formatting. With the Home tab of the ribbon displayed, click the Conditional Formatting option in the Styles group.

For instance, if you have a range of cells and you want to know which ones contain the letters 'shawn,' then you can do the following: You can use the conditional formatting feature in Excel to help draw attention to cells that contain specific text in which you are interested.

Excel for mac select cells with containing specific text