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

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

Mike H

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

Program buttons to create a word document 0
Cumulative formula for word table 0
Using If then to change cell colors in Excel 2007 5
Change Font Color Based on Conditional Formatting 8
Excel: want neg numbers to show red/pos green via if-then formula 3
Cell colour in relation to IF results 2
Show +/- totals in formulas in green vs. red colors 2
Conditional Formatting - Looking for Red/Yellow/Green Icons, w/ wo 0

Top