Thread
:
Conditional Formatting to display text in one cell according to whattext is displayed in another...Please Help
View Single Post
#
6
Posted to microsoft.public.excel.programming
Claus Busch
external usenet poster
Posts: 3,872
Conditional Formatting to display text in one cell according to what text is displayed in another...Please Help
Hi,
Am Thu, 21 Jan 2016 01:56:52 -0800 (PST) schrieb
:
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?
sorry, I thought you could create it by yourself.
Try:
=IF(ISNUMBER(SEARCH("apples",A1)),"apples",IF(ISNU MBER(SEARCH("banana",A1)),"banana","error"))
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch