This my first post here so firstly , hello everyone.
I am developing a spreadsheet which imports data from a charting program, my knowledge of excel is basic growing rapidly but I have no experience with VBA although I am going to have to dip a toe soon I can see that (gulp).
I first thought of displaying my data in a graphical format ie a variation of a multi layered box chart but I think that will have to wait due to my experience.
Here's where I am going with it:
The price is displayed in the centre of the screen. I have used a basic =sum("previous cell"=1) formula and pasted it above the realtime price and the same below using "-1"
This gives me constantly changing prices within the screen veiw. to display the opening price. other data is displayed using if statements in column next to the changing which are compared to a table containg the data. this results in a message displayed against the daily high and daily low in the column next to the prices and as the data changes these messages appear to rotate in veiw.
here is my question, I want to colour the cells between the high and the low (including the cell at the high and low which has the message) which are empty are empty. so that a coloured bar visually scrolls up or down as the trading prices gets nearer the high or low and obviously as the market reaches a new high the message will be disappear from the old price and be displayed at the new high or low with the formatting of the cells also updating. Can anyone tell me the simplist way of achievig this
Thanks in advance
I am developing a spreadsheet which imports data from a charting program, my knowledge of excel is basic growing rapidly but I have no experience with VBA although I am going to have to dip a toe soon I can see that (gulp).
I first thought of displaying my data in a graphical format ie a variation of a multi layered box chart but I think that will have to wait due to my experience.
Here's where I am going with it:
The price is displayed in the centre of the screen. I have used a basic =sum("previous cell"=1) formula and pasted it above the realtime price and the same below using "-1"
This gives me constantly changing prices within the screen veiw. to display the opening price. other data is displayed using if statements in column next to the changing which are compared to a table containg the data. this results in a message displayed against the daily high and daily low in the column next to the prices and as the data changes these messages appear to rotate in veiw.
here is my question, I want to colour the cells between the high and the low (including the cell at the high and low which has the message) which are empty are empty. so that a coloured bar visually scrolls up or down as the trading prices gets nearer the high or low and obviously as the market reaches a new high the message will be disappear from the old price and be displayed at the new high or low with the formatting of the cells also updating. Can anyone tell me the simplist way of achievig this
Thanks in advance