Conditional Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Select the entire sheet (A1 active), then apply CF using Formula Is:
=OR(A1="call",A1="meeting")
Format to taste, ok out
 
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
 
=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.)
 
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).

---
 
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!
 
Back
Top