Create Single Formatting Rule

Good morning,

So, I am creating a Report Component with, at least, 75 different data cells from Data Adapters.  When it comes to a Formatting Rule, I am looking for a single rule where the condition is dynamic based upon the value of the cell it is applied to.

This is just a small portion of the cells.  I would like to format all of them as ($##,###) in Red if it is negative.  I have tried using [Value] < 0 in the condition but everything is turning red.  I have created calcualted cells to turn any text into Decimal.  I don't want to have to create a rule for every cell.

Also, when it comes to the Format String, what is the syntax to make negative number show in parenthisis?