Home

new formula

trpick
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
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

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

=($A$1>=$A$2)*($A$1<=$A$3)
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies