Hello! I'm using Excel for Mac 2017 Version 15.41. I'm running into an issue I don't understand using conditional formatting.
I'm attempting to highlight a row one of three different colors depending on a specific condition. I have an upper limit, lower limit, and an age. If the age is below the lower limit nothing happens. If the age falls between the limits I want the row to turn yellow. If the age is above the upper limit the row turns green. For the yellow condition, this formula does exactly what I want it to do (the age = 2 and is $C$1 in all these examples):
=AND($C$1>=0, $C$1<=3)
However, I'd like to reference a cell instead of having a specific numerical value to the right of the equal sign in each argument. I entered the following formula but only one cell in the highlighted range turns yellow:
=AND($C$1>=B5, $C$1<=C5)
What do I need to change to have the entire selected range change color? When I get it right I want to be sure C1 is locked when I copy the formula (hence $C$1) but I'm not sure how to format the $ in the other cell references. Thank you in advance for your help and please let me know if more information is required!
<style></style>
I'm attempting to highlight a row one of three different colors depending on a specific condition. I have an upper limit, lower limit, and an age. If the age is below the lower limit nothing happens. If the age falls between the limits I want the row to turn yellow. If the age is above the upper limit the row turns green. For the yellow condition, this formula does exactly what I want it to do (the age = 2 and is $C$1 in all these examples):
=AND($C$1>=0, $C$1<=3)
However, I'd like to reference a cell instead of having a specific numerical value to the right of the equal sign in each argument. I entered the following formula but only one cell in the highlighted range turns yellow:
=AND($C$1>=B5, $C$1<=C5)
What do I need to change to have the entire selected range change color? When I get it right I want to be sure C1 is locked when I copy the formula (hence $C$1) but I'm not sure how to format the $ in the other cell references. Thank you in advance for your help and please let me know if more information is required!
<style></style>
