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
0 Comments
Leave a Reply. |