I want to insert an arrow into a cell that will change its shape and color, ie up or down - green or red, dependant on the relationship between two cells.
For example, if a current share price moves above its purchase price, I want the arrow to be upward and green and if it has moved down I want it to be downward and red.
I'd really appreciate some advice on this one?
For example, if a current share price moves above its purchase price, I want the arrow to be upward and green and if it has moved down I want it to be downward and red.
I'd really appreciate some advice on this one?