Explanation

• In MS Excel, Conditional Formatting is in the Home tab
• ..
• Apply conditional formatting to text
• Select the range of cells, the table, or the whole sheet that you want to apply conditional formatting to.
• On the Home tab, click Conditional Formatting.
• Point to Highlight Cells Rules, and then click Text that Contains.
• Type the text that you want to highlight, and then click OK.

• ****

  RY 16-01-2023