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

  • Thread starter Thread starter JOHN13
  • Start date Start date
J

JOHN13

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.
 
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
 
Back
Top