Hi,

Not totally sure about the flipping of data. I think you might be able
to achieve it by copying your data, then doing EditPaste
SpecialTranspose.

For the highlighting of positive and negative stocks, just do
Conditional Formatting. (FormatConditional Formatting). Set one
condition to greater than 0, the other to less than 0. Then add the
formatting that you want.

Hope that helps,

SamuelT


--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=546695