View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] mcorey2020@gmail.com is offline
external usenet poster
 
Posts: 4
Default Conditional Formatting to display text in one cell according towhat text is displayed in another...Please Help

Hi CLaus,

But I still need it to search the words *apples* and *bananas* and if neither word is displayed display error, how would I string to search multiple words and if none of them words are displayed then *error is displayed?