Function for validating multiple text values -- Conditional formatting rule with Formula

[viance]

Hi folks,

I'm trying to create a conditional formatting rule with a custom formula.

An IF OR function or ISNUMBER-SUMPRODUCT function might work but having troubles getting the function to work.

Here's the breakdown:
Lets say there's a value is in A1 and three potential values in Column B that relate to the value in A1. I'm trying to have a function that says:
IF value A1="Pop Music" and B2="Justin Bieber" or B2="Taylor Swift" or B2="Bruno Mars" -- if no match highlight row red

One thing to note is that A1 can be many genres of music -- Rap, Rock, etc. so the function will have many qualifiers. Column B values to validate will change per different genres.

IF value A1="Rap" and B2="YG" or B2="Travis Scott" or B2="Jay Z" -- if no match highlight row red
IF value A1="Rock" and B2="Nirvana" or B2="Rolling Stones" or B2="The Who" -- if no match highlight row red

Thank you for your help in advance!

Best,
V

[etaf]

you could make a list of those details
column A = genera
Column B the names
and then use
COUNTIFS()
see example

[viance]

Hi Etaf,

This worked great, thank you !

[etaf]

you are welcome

[viance]

Hi Etaf,

Quick question, how could I use similar excel logic above to include conditional formatting for a value that does not equal the above condtions?

IF value A1="Rap" and DOES NOT EQUAL B2="Brittney Spears" or B2="Bono" or B2="Boys to Men" -- if no match highlight row red.

Thanks in Advance,

Vince

[viance]

Nevermind, figured it out.

Easy as:
=COUNTIFS($U:$U,"<>"&$G12,$V:$V,"<>"&$H12)

Ty!