Use a custom cell format of

##,##0;[Red](#,##0)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"JK" wrote in message
...
Conditional Formatting

I want to change the font color of a number that is the negative value of
another number. I could conditionally format each cell individually, but
that
would be too time-consuming (lots of numbers.)

For example; D5 = 22,443 & D12 = (22,443)

If one cell is the opposite of another cell, change the font color to hide
the negative value.

Any help would be appreciated.
Thx in advance.