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?

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

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.