Conditional Formatting or ???

[brewster56]

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(F2>G2,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.

 

[Luke M]

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

 

[Sheeloo]

Are you trying to highlight H2?
What is the formula you are using for CONDITIONAL FORMAT?

 

[brewster56]

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.

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!*

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(F2>G2,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.

 

[brewster56]

Sheeloo ... not trying to highlight H2. The formula under conditional
formatting is:
=IF$f2>$c2 then I just apply formatting. I only have the one formula
because this works in the I2 perfectly. Both H2 and I2 are the same except
for the formula's in them