can colors be used in if test results eg red for minus amounts
 

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.

can colors be used in if test results eg red for minus amounts
 

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.

can colors be used in if test results eg red for minus amounts
 

Yes. Check out Conditional Formating.
--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



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