formatting

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...