I
ilan
Hi All,
I am setting up a spreadsheet that tracks the prices of share
movements for a lot of different shares. Once I import them into
Excel, they basically just form a grid, with date on the horizontal
axis, and share on the vertical. Amongst other things, I would like to
have a function which checks the data, and formats the cells that have
a trend identified. This would be a very simple trend, say, for a
share that has risen over three consecutive days, the text for the
share price of those three days is bolded and highlighted green. I
would like to apply other criteria as well, but all based along the
same lines.
The only way that I can think of doing this is to have a lot of
hiddens with calculations and flags, and then apply conditional
formatting, but this is very messy, and frankly is not something that
I would be prepared to do.
Is there another tool, perhaps using vb or otherwise that would allow
me to achieve the same results in an easier and cleaner way?
Thanks in advance,
Ilan
I am setting up a spreadsheet that tracks the prices of share
movements for a lot of different shares. Once I import them into
Excel, they basically just form a grid, with date on the horizontal
axis, and share on the vertical. Amongst other things, I would like to
have a function which checks the data, and formats the cells that have
a trend identified. This would be a very simple trend, say, for a
share that has risen over three consecutive days, the text for the
share price of those three days is bolded and highlighted green. I
would like to apply other criteria as well, but all based along the
same lines.
The only way that I can think of doing this is to have a lot of
hiddens with calculations and flags, and then apply conditional
formatting, but this is very messy, and frankly is not something that
I would be prepared to do.
Is there another tool, perhaps using vb or otherwise that would allow
me to achieve the same results in an easier and cleaner way?
Thanks in advance,
Ilan