Conditional ´formatting for negative values (plus why the HELL does CF result in a total????)

Man, the guy over at MS who is repsonsible for UX should be severly punished.  I don't know of any other tool that lets me jump through so many burning hoops.   I have a column that holds a percen...