I am trying to figure out how to subtract d1-B1 if cell is L but if cell is S then subtract B1-D1.
I would also like to add if number is negative to be in Red.

Thanks in advance!