Yeah, but you're using a SUM formula so the values are *calculated*.

Did you try what I suggested?

--
Biff
Microsoft Excel MVP


"Riccol" wrote in message
...
Thanks, Biff. But they're just regular numbers formatted in "accounting"
style to show two digits after the decimal ($ 0.00). I only ever enter
whole exact dollars & cents ($ 00.00) and I'm not using any formulas
anywhere that would result in more than two digits after the decimal (like
dividing might, for example) so there's no where that the actual value
would be differnt from the displayed value.


T. Valko wrote:
What kind of numbers are in these cells? If they're decimal values the
*displayed* value may not be the *true underlying* value. For example:

G162 true underlying value = 10.999999999999999

But it will display as 11. If D164 true underlying value = 11 then those
2 values do not match.

To fix that use rounding:

I always use the Formula Is option in conditional formatting...

=ROUND(G162,2)<ROUND(D164,2)