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

     

     

SamTN1974's avatar
SamTN1974
Copper Contributor
Jan 31, 2025

How do you do a conditional formatting if I have a word in column Y that I have to match to multiple words in column B, and I have to have the entire row highlighted A-AH. example is Ready in Y, and only the words, not available, and away in B needs to have the row highlighted.

Resources