Conditional format one word in a sentence
 

Hello
Is there a way to Conditional format specific words "names" on a sentence on the same cell without highligting the whole cell?

for example Bob Smith, Jack Taylor, Kevin Jackson, Tammy Taylor

Say if I have a list with Jack Taylor and Bob Smith
Would I be able to conditional format based on my list? so highlight just
Jack and Bob and not the rest of the names on the same cell?


Thank you

Conditional format one word in a sentence
 

Hi Jaime,

Am Tue, 5 Mar 2019 12:28:47 -0800 (PST) schrieb
:

for example Bob Smith, Jack Taylor, Kevin Jackson, Tammy Taylor

Say if I have a list with Jack Taylor and Bob Smith
Would I be able to conditional format based on my list? so highlight just
Jack and Bob and not the rest of the names on the same cell?

you connot highlight a part of a cell. But with a macro you can change
the font color for the expected names.
Have a look:
https://1drv.ms/x/s!AqMiGBK2qniTgeFA85HL-W3OOPwFSw
You must download the workbook because macros are disabled in OneDrive.


Regards
Claus B.
--
Windows10
Office 2016

Conditional format one word in a sentence
 

On Tuesday, March 5, 2019 at 2:28:50 PM UTC-6, wrote:
Hello
Is there a way to Conditional format specific words "names" on a sentence on the same cell without highligting the whole cell?

for example Bob Smith, Jack Taylor, Kevin Jackson, Tammy Taylor

Say if I have a list with Jack Taylor and Bob Smith
Would I be able to conditional format based on my list? so highlight just
Jack and Bob and not the rest of the names on the same cell?


Thank you





Thank you Claus

Conditional format one word in a sentence
 

On Tuesday, March 5, 2019 at 2:50:21 PM UTC-6, Claus Busch wrote:
Hi Jaime,

Am Tue, 5 Mar 2019 12:28:47 -0800 (PST) schrieb
:

for example Bob Smith, Jack Taylor, Kevin Jackson, Tammy Taylor

Say if I have a list with Jack Taylor and Bob Smith
Would I be able to conditional format based on my list? so highlight just
Jack and Bob and not the rest of the names on the same cell?

you connot highlight a part of a cell. But with a macro you can change
the font color for the expected names.
Have a look:
https://1drv.ms/x/s!AqMiGBK2qniTgeFA85HL-W3OOPwFSw
You must download the workbook because macros are disabled in OneDrive.


Regards
Claus B.
--
Windows10
Office 2016

Question Clause, I know on the Module it has "With the range (A1)
How about if I have more rows that I need to search? can I just add A1:A3 For example? so it can search more lines?

Conditional format one word in a sentence
 

Hi Jaime,

Am Tue, 5 Mar 2019 17:10:27 -0800 (PST) schrieb
:

Question Clause, I know on the Module it has "With the range (A1)
How about if I have more rows that I need to search? can I just add A1:A3 For example? so it can search more lines?

have another look:
https://1drv.ms/x/s!AqMiGBK2qniTgeFBvUhijTUjt-t15Q


Regards
Claus B.
--
Windows10
Office 2016

Conditional format one word in a sentence
 

On Tuesday, March 5, 2019 at 2:28:50 PM UTC-6, wrote:
Hello
Is there a way to Conditional format specific words "names" on a sentence on the same cell without highligting the whole cell?

for example Bob Smith, Jack Taylor, Kevin Jackson, Tammy Taylor

Say if I have a list with Jack Taylor and Bob Smith
Would I be able to conditional format based on my list? so highlight just
Jack and Bob and not the rest of the names on the same cell?


Thank you

Thank you again

Conditional format one word in a sentence
 

On Tuesday, March 5, 2019 at 3:28:50 PM UTC-5, wrote:
Hello
Is there a way to Conditional format specific words "names" on a sentence on the same cell without highligting the whole cell?

for example Bob Smith, Jack Taylor, Kevin Jackson, Tammy Taylor

Say if I have a list with Jack Taylor and Bob Smith
Would I be able to conditional format based on my list? so highlight just
Jack and Bob and not the rest of the names on the same cell?


Thank you

Hi Jaime, Aside from conditional formatting, here is a way using Characters inside a Sub:

https://drive.google.com/file/d/15Ji...ew?usp=sharing

Regards, Rich S.