Conditional Formatting or ???

  • Thread starter Thread starter brewster56
  • Start date Start date
B

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.
 
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
 
Are you trying to highlight H2?
What is the formula you are using for CONDITIONAL FORMAT?
 
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 said:
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 said:
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.
Click to expand...
Click to expand...
 
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
 
Back
Top