| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
| 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
