Conditional Formatting
 

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?

Conditional Formatting
 

Select the entire sheet (A1 active), then apply CF using Formula Is:
=OR(A1="call",A1="meeting")
Format to taste, ok out
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Betsy" wrote:
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?

Conditional Formatting
 

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

"Max" wrote:

Select the entire sheet (A1 active), then apply CF using Formula Is:
=OR(A1="call",A1="meeting")
Format to taste, ok out
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Betsy" wrote:
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?

Conditional Formatting
 

=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.)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Betsy" wrote:
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

Conditional Formatting
 

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("m eeting",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).
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Conditional Formatting
 

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!

"Max" wrote:

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("m eeting",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).
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Conditional Formatting
 

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

http://cjoint.com/?igr0svfXIl
Betsy_CF.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Betsy" wrote:
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!

Conditional Formatting
 

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

"Max" wrote:

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

http://cjoint.com/?igr0svfXIl
Betsy_CF.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Betsy" wrote:
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!

Conditional Formatting
 

glad to hear that, Betsy. you're welcome
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
On Aug 7, 1:58 am, Betsy wrote:
That got it! Don't know what I was doing wrong! Thanks again!!!!!!!