View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] jaime.calderon816@gmail.com is offline
external usenet poster
 
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