1

I'm trying to set a colour range of conditional formatting based on another cells value. So if A1 is larger than A2 it will be Blue, if A1 is between 0 and A2 it will be Yellow and if A1 is less than 0 it will be red.

I'm struggling with the second function - if A1 is between 0 and A2 it will be Yellow. Please can someone advise how to do this?

New contributor
Matt is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
1

Two solutions.


A/ Either you do a condition for each case

=A1>A2             BLUE

=AND(A1>0,A1<A2)   YELLOW

=A1<0              RED

B/ You set the cell in yellow and put only 2 condition format rules.

=A1>A2             BLUE

=A1<0              RED

Your Answer

Matt is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.