Forum Discussion

BobbyM23's avatar
BobbyM23
Copper Contributor
Aug 24, 2020
Solved

Conditional formatting for entire row if one of multiple words appears in a column

I need help setting a conditional format for my spreadsheet. My data goes from cell A1 thru I whatever depending on the size of my report each day. Row 1 is my header line. Column F is where my crit...
  • wumolad's avatar
    wumolad
    Aug 24, 2020

    BobbyM23 

     

    If you prefer to "hardcode" the words in the formula, then this should do:

     

    =OR(ISNUMBER(SEARCH("NEUROLOGY",$F2)),ISNUMBER(SEARCH("INTERVENTIONAL",$F2)),ISNUMBER(SEARCH("OPHTHALMOLOGY",$F2)))

     

    Cheers

     

     

BobbyM23's avatar
BobbyM23
Copper Contributor
Aug 24, 2020
wumolad I did see this option and I am being OCD and seeing if there is a way without setting the words in another column or table like that. I will keep this formula in my notes though in case I am not able to find what I am looking for.
wumolad's avatar
wumolad
Steel Contributor
Aug 24, 2020

BobbyM23 

 

If you prefer to "hardcode" the words in the formula, then this should do:

 

=OR(ISNUMBER(SEARCH("NEUROLOGY",$F2)),ISNUMBER(SEARCH("INTERVENTIONAL",$F2)),ISNUMBER(SEARCH("OPHTHALMOLOGY",$F2)))

 

Cheers