Forum Discussion

Brandy McWhorter's avatar
Brandy McWhorter
Copper Contributor
Aug 10, 2018

Problem with conditional formatting?

Hi, I am having issues with trying to apply conditional formatting to my sheet.  In column K I have the following doctors names Garnett/McCusker, Dar/McCusker, Childers/McCusker  and then just Garne...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 10, 2018

Hi Brandy,

 

You may apply to column A (starting from A3 if apply to $A$3:$A$999 or so) the rule with formula

=ISNUMBER(SEARCH("McCusker",$K3))

and attached

  • Brandy McWhorter's avatar
    Brandy McWhorter
    Copper Contributor
    Aug 10, 2018

    Thank you so much. It worked. I have been working on this all day. 

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Aug 11, 2018

      You are welcome