Conditional formatting with IF function

[Guest]

A B

1 Apple 10
2 Apple 5
3 Orange 14
4 Orange 17

I want to highlight column B in such a way that IF column A1= Apple and
value in column B1 in not between 6-9, highlight column B in red; IF A1 =
orange and value in column B not between 15-18, highlight in red too. How to
do this? Thanks in advance for reply.

 

[David Biddulph]

Format/ Conditional formatting
Formula is:
=OR(AND(A1="Apple",OR(B1<6,B1>9)),AND(A1="Orange",OR(B1<15,B1>18)))
Choose your red highlighting format.

 

[Bob Phillips]

Us conditional formatting with a formula of

=OR(AND(A1="Apple",OR(B1<6,B1>9)),AND(A1="Orange",AND(B1<15,B1>18)))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)