Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #108447
| From | Claus Busch <claus_busch@t-online.de> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: Conditional Formatting to display text in one cell according to what text is displayed in another...Please Help |
| Date | 2016-01-20 17:46 +0100 |
| Organization | A noiseless patient Spider |
| Message-ID | <n7odfc$a6f$1@dont-email.me> (permalink) |
| References | <ec466e33-17ab-4e10-9e38-4f2f713630e2@googlegroups.com> |
Hi, Am Wed, 20 Jan 2016 04:23:44 -0800 (PST) schrieb mcorey2020@gmail.com: > 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
Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Conditional Formatting to display text in one cell according to what text is displayed in another...Please Help mcorey2020@gmail.com - 2016-01-20 04:23 -0800
Re: Conditional Formatting to display text in one cell according to what text is displayed in another...Please Help Claus Busch <claus_busch@t-online.de> - 2016-01-20 17:46 +0100
Re: Conditional Formatting to display text in one cell according to what text is displayed in another...Please Help mcorey2020@gmail.com - 2016-01-20 12:13 -0800
Re: Conditional Formatting to display text in one cell according to what text is displayed in another...Please Help Claus Busch <claus_busch@t-online.de> - 2016-01-21 06:00 +0100
Re: Conditional Formatting to display text in one cell according to what text is displayed in another...Please Help mcorey2020@gmail.com - 2016-01-21 01:56 -0800
Re: Conditional Formatting to display text in one cell according to what text is displayed in another...Please Help Claus Busch <claus_busch@t-online.de> - 2016-01-21 11:05 +0100
Re: Conditional Formatting to display text in one cell according to what text is displayed in another...Please Help mcorey2020@gmail.com - 2016-01-21 03:11 -0800
csiph-web