Hello, I want to change the value of a cell based on the value of another cell.
Example:
I want A1 to change color based on the value of A5.
Here are the values. I am not sure how to get them to change between two numbers e.g. 0 & 0.5, 0.5 & 1,5 etc.
Between 0 and 0.5 = Dark Green
Between 0.5 and 1.5 = Light Green
Between 1.5 and 2.5 = Yellow
Thank you!
Example:
I want A1 to change color based on the value of A5.
Here are the values. I am not sure how to get them to change between two numbers e.g. 0 & 0.5, 0.5 & 1,5 etc.
Between 0 and 0.5 = Dark Green
Between 0.5 and 1.5 = Light Green
Between 1.5 and 2.5 = Yellow
Thank you!