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!
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/