Feb 02 2019 03:30 PM
O.K.
I'm new, here is what I want to do
Cell A1 has a $ amount
Cell A2 has a $ amount
Cell A3 has a $ amount
I want to format Cell B1 to Change Cell Color when Cell A1 is greater then or equal to A2 but Less than or equal to A3
thank you and Help!
Feb 03 2019 05:09 AM
Feb 03 2019 05:17 AM
The formula for conditional formatting rule, applied to B1, could be
=($A$1>=$A$2)*($A$1<=$A$3)