Excel 2007 - Need help with conditional formatting

#1
Hi members,

I am trying to apply conditional formatting to an excel sheet in excel 2007, but not successful.

please help.

1. When column A says BUY to corresponding cell in column D should remain +ve number.

2.
1. When column A says SELL to corresponding cell in column D should remain -ve number. (in sheet Cell 3D should become -14002 & 4D should become -13541)

Thanks, aman
 
Last edited:
#3
Hi - I have linked my NEST Trader with Excel and therefore all rates are getting published on Excel on Real Time basis tick by tick. Now what I to know is... if and how it is possible to create 5 min / 10 m / 15 min OHLC using that live feed. Please let me know any formula or app doing this for me.
Regards,
Vishal
 

Similar threads