M
Michael
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.
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.