The steps to use conditional formatting in Excel

1. Choose the range of cells, tables, or entire sheets to which you want to apply conditional formatting.
2. Select Conditional Formatting from the Home tab.
3. Select Highlight Cells Rules and then Text that Contains.
4. Enter the text you want to highlight, then click OK.