I am using this custom format to reflect percentages as a number, carrying it to two decimals #,##0.00,, but I need it to show up in [Red] and in parentheses when it's a negative number. I've experimented but nothing's worked.

Suggestions?