Author: Oscar Cronquist Article last updated on October 18, 2018

Excel allows you to quickly highlight cells containing a given text string.

How to apply Conditional Formatting

  1. Select cell range.
  2. Go to tab "Home" on the ribbon if you are not already there.
  3. Click "Conditional formatting" button.
  4. Click on "Highlight Cells Rules".
  5. Click "Text that Contains..."
  6. A dialog box appears that lets you specify the text string and the formatting. Click the arrow to select a cell value that contains the text string to be used, in this case, cell C14.
  7. Pick a formatting or use a custom format.
  8. Click OK button.