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

     

     

SqueakySneakers's avatar
SqueakySneakers
Brass Contributor
Aug 24, 2020

BobbyM23 

Highlight all the cells down F1 you want to format. Click on Conditional formatting and select New Rule, Use Formula. put =OR(F1="Neurology",F1="Intervention",F1="Ophthalmology") then select Format, and choose your format. Say ok until you are out.

 

Resources