How to show if a cells value was an increase or decrease using conditional formatting

Thankyou for any help you can offer on this. I have been working on it for 2 hours and cant think of how to resolve it. Any suggestions would be greatly appreciated.

I have a cell (A1) in Excel that constantly changes. It calls price data from another website and updates every 10 seconds.

I would like to create an arrow indicator in cell B1 that shows whether the current price in Cell A1 is greater or less than the last price is showed in A1.

In effect, if cell A1 showed a price of $1 and then changed to $1.5 I would like Cell B1 to show a green arrow indicating that the price moved up. Conversely if A1 showed a price of $1 and then updated to show a price of $0.75 I would like B1 to show a red down arrow indicating that the price is going down. Thankyou

Hi there,

Take a look at the attached workbook and see if it does what you need. It uses the following code inserted in the VBA CodeModule of the worksheet whose values you want to monitor:

Please Login or Register  to view this content.

Note: The font of Cell B1 (Pointer Cell) is set as "Wingdings"

The highlighted values may be altered to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

Hi again,

The following modification is VERY slightly better than the original version:

Please Login or Register  to view this content.

Regards,

Greg M

Hi, thanks very much for suggestions and the workbook example, much appreciated. I'm a complete novice with this stuff so really sorry if this question sounds silly but when I open the workbook there are 3 cells. If I change cell A1 it doesn't change the arrow in B1. Should I be updating it another way to get the arrow to change? thanks again for helping

Hi again,

Many thanks for your feedback and also for the Reputation increase - much appreciated!

When I open the workbook I posted, the value 111 is displayed in Cell A1. If I change this value to 222 the green up-arrow is displayed in Cell B1. If I change the value in Cell A1 back to 111 the red down-arrow is displayed in Cell B2.

Hope this helps, but feel free to ask if you need any further information.

Best regards,

Greg M

hi Greg thanks for the reply and help , yes i tried the same as you but it doesn't work for me. The arrow in B1 dosnt change. It says macros have been blocked. not sure if that is what is preventing it from working. should enable macros?

ah yes, perfect, all working.. that's great !! and Greg this is perfect for what I need, thankyou so much really appreciate your help..

Hi again,

Great! Glad to have that feedback and to hear that everything's working correctly for you now.

Regards,

Greg M

This is still a modification of Greg M's code, not requiring an auxiliary cell (C1)

Please Login or Register  to view this content.

Artik