I forgot to to check for duplicate entries of a keyword, so I ran it on a processed food allergy list (humungous entries for wheat) If there are If theere are likely to be duplicates in a cell this will tak care of it. 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.
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.
0 kommentar(er)
