Google Sheets Conditional Formatting with AND for value range

by Matt   Last Updated September 11, 2019 11:03 AM - source

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?

Thanks!



Related Questions


How to left align dollar symbol but right align number?

Updated February 16, 2018 18:03 PM