new formula

Highlighted
Occasional Visitor

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!

 

 

2 Replies
Highlighted
Hello @trpick,
Leave your B1 selected, then go to home tab -> Condional formatting. Check the videos on this topic, e.g. https://m.youtube.com/watch?v=aNW8_52CL58

Greets, Eva
Highlighted

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

=($A$1>=$A$2)*($A$1<=$A$3)