Unless you specifically change them to another color, they should
automatically appear in black. Only the negative numbers should appear in
red.


"Seanie" wrote in message
...
Thanks, quite an imaginative piece of code

This changes all values that are currently less than 1 to a minus red,
but how can I change even values that are positive to to show as
1,234.56 (in black) - I know theu won't change, but this way it helps
me maintaining my sheet going forward