formatting currency and negatives

Apr 17, 2014 at 2:47 PM
how do you format numbers as currency and also make it so that the negatives are shown in red with the ($1234.56) formatting?