John,

First off kill the caps, it's hard to read and is considered rude. Format
your formula cell with this

[Green]#,##0;[Red]-#,##0

Mike

"JOHN13" wrote:

IN WRITING IF TESTS IWOULD LIKE TO HAVE THE RESULT PRINT IN RED FOR NEGATIVE
NUMBERS AND BLACK OR GREEN FOR POSITIVE. CAN THIS BE DONE.