Forum Discussion
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 equal to A2 but Less than or equal to A3
thank you and Help!
2 Replies
The formula for conditional formatting rule, applied to B1, could be
=($A$1>=$A$2)*($A$1<=$A$3)
- 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
