Google Sheets Conditional Formatting with AND for value range

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

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


Updated February 16, 2018 18:03 PM

Updated June 01, 2015 01:01 AM

Updated September 04, 2018 22:03 PM

Updated August 09, 2019 10:03 AM