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. Press with left mouse button on "Conditional formatting" button.
  4. Press with mouse on "Highlight Cells Rules".
  5. Press with left mouse button on "Text that Contains..."
  6. A dialog box appears that lets you specify the text string and the formatting. Press with left mouse button on 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. Press with left mouse button on OK button.