![]() ![]() And then click Format button, in the popped out Format Cells dialog box, click Fill tab, and then choose one color to highlight the specific cells you need. Note: In the formula, “ sheet” is partial text which you want to search cells based on, A2 is the first cells within the selected range of cells.ģ. In the New Formatting Rule dialog box, click Use a formula to determine which cells to format option in the Select a Rule Type list box, and then enter this formula: =search(“sheet”,A2) into the Format values where this formula is true text box, see screenshot: Select the text list that you want to highlight the cells which contain partial text, and then click Home > Conditional Formatting > New Rule, see screenshot:Ģ. ![]() In fact, the Conditional Formatting in Excel can help you to highlight the cells if contain partial text as quickly as you need. Highlight the cells which contain partial text by using Kutools for Excel Highlight the cells which contain partial text by using Conditional Formatting This article, I will talk about some quick tricks to deal with this task. Is it possible for us to highlight the cells which contain partial text within the cell? For example, I want to search for the cells which contain the text “sheet” and then highlight them as following screenshot shown. ![]() How to conditional formatting if the cell contains partial text in Excel? ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |