Conditional Formatting Excel Based On Text. You can use the search option to highlight specific cells in. A dialog box as shown in the picture below will open.
Then click the conditional formatting button on the home tab hover your mouse over hightlight cells rules and click text that contains. Go to home tab conditional formatting new rule. Conditional formatting in excel can be used in various ways.
Click the last option.
Excel conditional formatting based on another cell text 5 ways highlighting cells based on another cell text with formula. Conditional formatting in excel can be used in various ways. Then select the last option which is use a formula to determine which cells to format from the list. Go to home tab conditional formatting new rule.
