Thank you Luke, but I used [Red][<0]($#,##0.00);General when I formatted the
cell in H2 and it did not work. It did not give me the ($xxx.xx) format but
did give the red. It also gave me 3 digits after the decimal place.

"Luke M" wrote:

Your conditional formatting to get the correct colors should be good. But, to
get the exact formatting you're wanting for negative values, try using this
custom format on H2.
[Red][<0]($#,##0.00);General
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"brewster56" wrote:

For a currency calc., I make a comparison between 2 values. If one value is
greater than another - color = green. If same comparision yields no change -
then color = black, if comparison yields less than value - color = red (but
want to format using ($xxx.xx).

Here is calc I use in H2 : =IF(F2G2,E2*F2,E2*G2). E2;F2;G2 are all number
fields. E2;F2 contain actual numbers, while G2 contains the following
formula =C2-(C2*0.1).

I get it to work to a degree, but not perfectly. I get the red/green/black -
but NOT the ($xxx.xx) when red (less than) comparison.

Is it because of the formula I use if H2 ? Because the column right beside
it (I2) has the following formula and works perfectly =SUM(H2-D2). That is
the only real difference between the columns.