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


"Sheeloo" wrote:

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

"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.