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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies