Share via

Conditional Formatting with Specific Text

Anonymous
2020-08-06T16:50:15+00:00

I wanted to do Conditional Formatting with Specific Text but include multiple words.  For Example, I want to Format only Cells with Specfi8c Text containing either Logistics or Tech. It works if I only put one, but not if I have two words.  is there a way to say "or" in conditional formatting formulas?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2020-08-06T18:31:37+00:00

    Hi Rose

    Please try

    =OR(ISNUMBER(SEARCH("Logistics",$A1)),ISNUMBER(SEARCH("Tech",$A1)))

    Note:

    Format the cells as you prefer

    Change the ranges in the formula according to your scenario

    I hope this helps you

    Regards

    Jeovany

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-08-08T22:21:15+00:00

    Hi Rose,

    Have you seen Jeovany’s reply? If you have any updates, please feel free and come back to share with us.

    Regards,

    George

    0 comments