Conditional Formatting to display text in one cell according to whattext is displayed in another...Please Help
 

I need to make an excel cell find a value in another cell and if the value is there display a specific word in the selected cell, so basically the text in a1 is either 'a' or 'b' or maybe that value isn't there. So in b1 I need a formula to search a1 for text 'a' or 'b' and if it finds 'a' it displays 'Apple', if it finds 'b' then it displays 'banana' and if it finds neither of those values then it displays 'error'

Please Help Me!!

Conditional Formatting to display text in one cell according to what text is displayed in another...Please Help
 

Hi,

Am Wed, 20 Jan 2016 04:23:44 -0800 (PST) schrieb :

I need to make an excel cell find a value in another cell and if the value is there display a specific word in the selected cell, so basically the text in a1 is either 'a' or 'b' or maybe that value isn't there. So in b1 I need a formula to search a1 for text 'a' or 'b' and if it finds 'a' it displays 'Apple', if it finds 'b' then it displays 'banana' and if it finds neither of those values then it displays 'error'

try:
=IF(A1="a","Apple",IF(A1="b","Banana","Error"))


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Conditional Formatting to display text in one cell according towhat text is displayed in another...Please Help
 

Cheers Claus! Appreciate it!!

What about if I want it to search for the word 'apples' but there was for instance "apples and pairs" text in the cell, it doesn't search within that specific phrase?

Conditional Formatting to display text in one cell according to what text is displayed in another...Please Help
 

Hi,

Am Wed, 20 Jan 2016 12:13:27 -0800 (PST) schrieb :

What about if I want it to search for the word 'apples' but there was for instance "apples and pairs" text in the cell, it doesn't search within that specific phrase?

try:
=IF(ISNUMBER(SEARCH("Apples",A1)),"a","")


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

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?

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

Conditional Formatting to display text in one cell according towhat text is displayed in another...Please Help
 

On Thursday, January 21, 2016 at 10:05:35 AM UTC, Claus Busch wrote:
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

Your support is much appreciated!!

I found a formula that works;

=IF(COUNT(SEARCH({"Apples","Bananas","Carrots"},C1 )),"Fruit","error")

Thank you for your help though!