Share via

Conditional Formatting if cell contains one item of a provided list

Anonymous
2023-01-17T11:45:42+00:00

Hi there,

Is it somehow possible to set just one CF rule that contains a list of names?

FX. I would like all cells in column B to turn red IF cell contains one of the names in a provided list.

So instead of saying turn red if cell contains Barbara, it should be:

Turn red if cell contain Barbara or Julia or Monica or Simone or ...

Is this possible or I have to create 100+ rules each one with a name?

Thanks a lot for helping

Microsoft 365 and Office | Excel | For business | 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

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-01-17T12:18:14+00:00

    Hi Ele,

    Greetings! Thank you for posting to Microsoft Community.

    Do you mean if AAA1 is in column A， then apply format on it?

    Best Regards,

    Snow Lu

    0 comments
  2. Anonymous
    2023-01-17T12:31:09+00:00

    Hi Snow Lu!

    thanks for replying...

    What I mean is:

    If AAA1 or AAA3 or AAA6 are in column 1 then apply format

    Is this possible?

    thanks!

    0 comments
  3. Anonymous
    2023-01-17T12:41:23+00:00

    Try =COUNTIF($D:$D,A1)=1

    0 comments