Solved

Searching for "word" within a cell

Posted on 2014-12-12
2
72 Views
1 Endorsement
Last Modified: 2014-12-13
Column B contains part numbers. Column C contains descriptions of those part numbers. both columns are dynamic as the part numbers in column B are pasted from another source.

Each cell in column C will contain one or more words that need to be searched. There are 23 potential words. (4 character alpha-numeric)

In column D the 23 words with descriptions exist in 23 rows.

What I am hoping to accomplish is that when one or more words that are found in each cell in column C that will highlight that word / cell in column D

Thanks for any assistance/suggestions
1
Comment
Question by:dgd1212
2 Comments
 
LVL 49

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 40497676
HI,

pls replace in the example the formula of the Conditional formatting in D2 with the one in cell E2

=(SUM(IFERROR(SEARCH(D2,$C$2:$C$5),0)))>0

Regards
EE20141213.xlsx
0
 

Author Comment

by:dgd1212
ID: 40498391
Thank you!
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

806 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question