Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find a word in a sentence | Excel Worksheet Functions | |||
If for word in sentence | Excel Programming | |||
If for word in sentence | Excel Programming | |||
Link a cell to a word in a sentence | Excel Discussion (Misc queries) | |||
how to keep a word of same sentence starting w a capital next lin | Excel Worksheet Functions |