Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 5th 19, 08:28 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2016
Posts: 18
Default 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


  #2   Report Post  
Old March 5th 19, 08:50 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,669
Default 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
  #3   Report Post  
Old March 5th 19, 09:17 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2016
Posts: 18
Default 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

  #4   Report Post  
Old March 6th 19, 01:10 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2016
Posts: 18
Default 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?
  #5   Report Post  
Old March 6th 19, 07:09 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,669
Default 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


  #6   Report Post  
Old March 6th 19, 12:55 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2016
Posts: 18
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find a word in a sentence Chicago2Paris Excel Worksheet Functions 10 October 29th 09 06:29 PM
If for word in sentence Paul C Excel Programming 1 April 9th 09 09:40 PM
If for word in sentence Graham H Excel Programming 2 April 9th 09 09:30 PM
Link a cell to a word in a sentence Brenelder Excel Discussion (Misc queries) 1 March 14th 08 08:36 PM
how to keep a word of same sentence starting w a capital next lin dottie Excel Worksheet Functions 1 September 20th 07 05:32 PM


All times are GMT +1. The time now is 12:58 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017