Home/ Questions/Q 865
Next
Answered
computing
  • 0
Asked: 2021-10-19T02:10:35+00:00 In:

Solved search multiple words in excel 2010

  • 0

I need to seach a column, or an entire worksheet, for more than one term. For example, I want to find “red” or “blue”. Why is this so difficult?

Filtering doesn’t help because there are 100’s of cells in the column with different terms. If I filtered, I would have to scan the filter selections manually, which wouldn’t be any easier than looking at the document.

Would it help that the mulitiple terms are the same for each doc? Thanks!

Share

    1 Answer

    1. Best Answer
      You could also use Conditional Formatting to highlight those cells with your target words in them.

      If you have 2007,

      1) Select your cell or range of cells
      2) On the ribbon click Conditional Formatting
      3) Select Highlight Cells Rules
      4) Select Text That Contains
      5) In the input Box enter your text string, IE: Red
      6) Click OK

      All the cells in your selected range, that contain the word Red should
      now be highlighted

      You could also change the color for each word, so the text string Red
      shows up one color, the text string Blue another.

      .

      MIKE

      http://www.skeptic.com/

      • 0