EXCEL Gurus (Dick Dastardly)

I'm trying to set up a trading log chart however I'm useless with Excel functions. I'm trying to say the below If A1=Buy then D1=C1-B1 or if A1=Sell then D1=B1-C1 Is it possible to add in an automated color depending on whether the resulting number is pos..