Conditional formatting with IF function
 

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.

Conditional formatting with IF function
 

Format/ Conditional formatting
Formula is:
=OR(AND(A1="Apple",OR(B1<6,B19)),AND(A1="Orange", OR(B1<15,B118)))
Choose your red highlighting format.
--
David Biddulph

"Michael" wrote in message
...
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.

Conditional formatting with IF function
 

Us conditional formatting with a formula of

=OR(AND(A1="Apple",OR(B1<6,B19)),AND(A1="Orange", AND(B1<15,B118)))

--
---
HTH

Bob

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



"Michael" wrote in message
...
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.