Thread
:
Conditional Formatting to display text in one cell according to whattext is displayed in another...Please Help
View Single Post
#
4
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 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
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch