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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using If then to change cell colors in Excel 2007 3
how can I use conditional formatting with formula and 3 poss resul 1
Change Font Color Based on Conditional Formatting 8
Excel: want neg numbers to show red/pos green via if-then formula 3
Reverse color numeric formatting? 2
Using count function for multiple columns 1
Show +/- totals in formulas in green vs. red colors 2
How to give numbers to the font colors 2

Back
Top