| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting if condition of an if statement is true and astring value is displayed | Excel Programming | |||
| Display conditional formatting if cell value equals an integer | Excel Worksheet Functions | |||
| Having a cell display certain text or formatting when the worksheet is protected or unprotected | Excel Programming | |||
| Cell Formatting Advice:- Text displayed as .........####### | Excel Discussion (Misc queries) | |||
| Why won't my conditional formatting display in the cell | Excel Discussion (Misc queries) | |||
Threaded Mode
