Forum Discussion
trpick
Feb 02, 2019Copper Contributor
new formula
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 equa...
SergeiBaklan
Feb 03, 2019Diamond Contributor
The formula for conditional formatting rule, applied to B1, could be
=($A$1>=$A$2)*($A$1<=$A$3)