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?