conditional formatting excel 2016 equals cell

Conditional Formatting on Text that Contains Multiple Words in Excel.Conditional Formatting Multiple Text Values in Excel (4 Easy Ways).

Excel Conditional Formatting with Formula If Cell Contains 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

Conditional formatting excel 2016 equals cell