Conditional Formatting Assistance

[Disarmonious]

I have two cells, A1 and B1, and I want the text in cell B1 to turn red if "A1=Apple" or "A1=Orange" or "A1=Banana" AND "B1=Pink" or "B1=Purple" or "B1=Blue"

I'm looking for the shortest formula to make this work because I want to avoid doing it the long way by entering a bunch of AND formulas that would turn the text in cell B1 to red.

Thank you in advance!

 

[dreid1011]

This is probably the shortest you're going to get:

=AND(OR(A1="Apple",A1="Orange",A1="Banana"),OR(B1="Pink",B1="Purple",B1="Blue"))

 

[dreid1011]

This is probably the shortest you're going to get:

=AND(OR(A1="Apple",A1="Orange",A1="Banana"),OR(B1="Pink",B1="Purple",B1="Blue"))

However, you could use a lookup table if you have many possible values:

Book1
	A	B	C	D	E	F	G	H
1	Apple	Pink	TRUE				Apple	Pink
2	Orange	Pink	TRUE				Orange	Purple
3	Banana	Yellow	FALSE				Banana	Blue
4	Apple	Purple	TRUE
5	Pear	Purple	FALSE
6	Banana	Purple	TRUE
7	Apple	Green	FALSE
8	Orange	Blue	TRUE
9	Banana	Blue	TRUE
Sheet1

Cell Formulas
Range	Formula
C1:C9	C1	=AND(ISNUMBER(MATCH(A1,$G$1:$G$3,0)),ISNUMBER(MATCH(B1,$H$1:$H$3,0)))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C1:C9	Expression	=AND(ISNUMBER(MATCH(A1,$G$1:$G$3,0)),ISNUMBER(MATCH(B1,$H$1:$H$3,0)))	text	NO
B1:B9	Expression	=AND(OR(A1="Apple",A1="Orange",A1="Banana"),OR(B1="Pink",B1="Purple",B1="Blue"))	text	NO

 

[Disarmonious]

Amazing! Thank you for your expertise! I appreciate you taking the time to assist me with this inquiry! I will attempt both recommendations to see which would be a better fit!

 

[dreid1011]

You're welcome, and happy to help.