Conditional Formatting Formula setup required

[firefly10]

I have a question regards to conditional formatting (highlighting) and what formula to use please.


I have 4 rows A, B, C, D


If A2 has any of these numbers - 1, 2, 3 and "D2" has any of apple, oranges, grapes, banana. I like the "ABCD" to highlight green.
If A3 has any of these numbers - 4 , 5, and "D2" has any of cauliflower, egg plant, capsicum, chillies etc. I like the "ABCD" to highlight yellow.


what formula to use please and many thanks in advance for your time and response.

 

[DanteAmor]

Formula

=AND(AND($A2>=1,$A2<=3),Or($D2="apple",$D2= "oranges",$D2="grapes",$D2="banana"))

Aplplies to:
=$A$2:$D$2

 

[firefly10]

Many thanks works wonderful

 

[firefly10]

What would the formula
If A2 was 1,2,3,14 and rest same

 

[DanteAmor]

Many thanks works wonderful

I'm glad to help you. Thanks for the feedback.

 

[DanteAmor]

What would the formula
If A2 was 1,2,3,14 and rest same

=AND(OR(AND($A2>=1,$A2<=3),$A2=14),Or($D2="apple",$D2= "oranges",$D2="grapes",$D2="banana"))

 

[firefly10]

You awesome!
Many Thanks

 

[DanteAmor]

You're welcome.