Conditional Formatting

[Guest]

I have a huge spreadsheet. I need to search for every cell that contains the
word "call" or "meeting" and highlight that cell.

How do I do this using conditional formatting?

 

[Guest]

Select the entire sheet (A1 active), then apply CF using Formula Is:
=OR(A1="call",A1="meeting")
Format to taste, ok out

 

[Guest]

Thanks. I must be doing something wrong. I selected the whole worksheet
((A1 active) then selected "formula is" from the dropdown, then thped
=or(A1="call,A1="meeting") I then selected format and used the Patterns tab
and selected a shade. Nothing happened

 

[Guest]

=or(A1="call,A1="meeting")
you had a typo in the above, it should be "call"

But if it still doesn't work despite the correction, then try this more
robust:
=OR(TRIM(A1)="call",TRIM(A1)="meeting")

(there could be leading or trailing white spaces for the 2 words keyed into
cells which are not readily apparent. TRIM will take care of these.)

 

[Guest]

If the 2 words: call, meeting could be part of a text string within the same
cell,
use this rendition instead:
=OR(ISNUMBER(SEARCH("call",A1)),ISNUMBER(SEARCH("meeting",A1)))

Replace SEARCH with FIND if you need it to be stricter, case-sensitive.
SEARCH is not case sensitive.

The earlier 2 suggestions assume that the cell(s) would contain only the
word(s).

---

 

[Guest]

Yes, the words are part of a text string within the cell. I tried this and
it still didn't work! I double-checked my typing on the formula and typed it
exactly like you showed below.

Any other suggestions? And by the way, thanks for all your help!

 

[Guest]

Here's a quick sample to illustrate that it works
(contains a screenshot of the CF dialog):

http://cjoint.com/?igr0svfXIl
Betsy_CF.xls

 

[Guest]

That got it! Don't know what I was doing wrong! Thanks again!!!!!!!

 

[Max]

glad to hear that, Betsy. you're welcome