![]() ![]() 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |