Excel for mac select cells with containing specific text

In the New Formatting Rule dialogue box select Format only cells that contain and, in the Format only cells with option select Specific Text.

Now, select the New Rule from Conditional Formatting option under the Home tab.

First, select the cells where you want to apply the conditional formatting.

There is another detailed way to highlight cells with specific text.

In the same way, Green texts can be highlighted in the picture below.ДЄnother Process of Highlighting Text using Conditional Formatting.

You will find the below result by doing this.

In the Text That Contains dialogue box just select Yellow in Format cells that contain the text option and select Light Yellow Fill with Dark Yellow Text option and press OK.

Now, to highlight the Yellow text in the sheet do the following after you open the Text That Contain dialogue box.

You will get to see the below result after that.

In the Text that Contains dialogue box write Red in Format cells that contain the text option and select Light Red Fill with Dark Red Text option and press OK.

Under the Highlight Cells RulesВ option select the Text that Contains option.

Now, Under the Home tab select the Conditional Formatting option.

First, select the cells from which you want to perform the highlighting.

Let`s highlight the colors red, yellow, and green from the above list. From them, you want to highlight the colors red, yellow, and green. LetвЂ™s say you have some colors in three separate columns. Highlight cells containing specific text using вЂњHighlight Cells RulesвЂќД¬onditional Formatting makes it easy to highlight the cells which contain some specific text. Note: DonвЂ™t forget to select the range before applying the conditional formatting.

In the same way, if you want to find the students who failed the exam but can sit for a retake you just need to write вЂњRetakeвЂќ instead of вЂњPassвЂќ in cell C2.

You will get the below result after this.

Now press OK in the New Formatting Rule dialogue box to apply the formatting.

After this, you can see the color you choose in the Preview option.

In the Format Cells dialogue box under the FillВ option, select the color you want and press OK.

Click on the Format option to open the Format Cells dialogue box.

In the New Formatting Rule dialogue box select Use a formula to determine which cells to format and type =SEARCH($C$2, A1)>0 in Format values where this formula is true box.

Now, select the New Rule from Conditional Formatting option under the Home.

Select the range of cells where you want to apply the conditional formatting.

First, write down the text вЂњPassвЂќ in cell C2.

We will be targeting this cell to perform conditional formatting for the entire range of cells. Here in B2 cell, we have the text which is displaying вЂњPassed the ExamвЂќ. In this case, we will be identifying the cells containing the word вЂњPassedвЂќ. You can use the search option to highlight specific cells in conditional formatting. Further Readings Highlighting Cells Based on Another Cell Text with Formula

Excel for mac select cells with containing specific text