View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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
---