Hi.

-I am stuck on correct formula for Column U beginning with U9. The remaining shares would be U8 Plus (if any) E9 and less (if any) O9.
-I also tried to add colour to column W. Green if positive, Red if negative, Clear if value $0.
-Also colour for column U. Blue if positive value, clear if zero value.

Would appreciate the assistance.

Thank you.Gain Loss Report.xls