Thread
:
Conditional format one word in a sentence
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
[email protected]
external usenet poster
Posts: 18
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?
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]