new formula

Occasional Visitor


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!



2 Replies
Hello @trpick,
Leave your B1 selected, then go to home tab -> Condional formatting. Check the videos on this topic, e.g.

Greets, Eva

The formula for conditional formatting rule, applied to B1, could be