Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting for text?
Is there a conditional formula for inserting text into specific cells?
Example: I want to insert a company name into cell B3 and I want B4 to auto-populate the street address, then b5 the city,state,zip, b6 the phone number, etc. There would be approx. 5 company names in that first selection option. Any help would be appreciated. -- Kevin Hromas Proadjuster.org |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting for text?
Sounds like you need to create a lookup table. See if this helps:
http://contextures.com/xlFunctions02.html -- Biff Microsoft Excel MVP "Kevin" wrote in message ... Is there a conditional formula for inserting text into specific cells? Example: I want to insert a company name into cell B3 and I want B4 to auto-populate the street address, then b5 the city,state,zip, b6 the phone number, etc. There would be approx. 5 company names in that first selection option. Any help would be appreciated. -- Kevin Hromas Proadjuster.org |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting of a text box ? | Excel Worksheet Functions | |||
Conditional Formatting based on text within a cell w/ text AND num | Excel Worksheet Functions | |||
Conditional Formatting based on Text within Text | Excel Discussion (Misc queries) | |||
Conditional formatting of text | New Users to Excel | |||
Conditional Formatting of Text... | Excel Discussion (Misc queries) |