I want the sum to be red if it's minus and black if it's plus.
P pinmaster Jan 28, 2006 #2 If your data in currency then go to Format/Cells and select Currency then negetive red numbers from the list on the right. If regular numbers then use a custom format: #,##0.00;[Red]-#,##0.00 HTH JG
If your data in currency then go to Format/Cells and select Currency then negetive red numbers from the list on the right. If regular numbers then use a custom format: #,##0.00;[Red]-#,##0.00 HTH JG
G George King Jan 28, 2006 #3 Another way to do this is Conditional Formatting. Go to 'Format' - 'Conditional formatting' and set criteria for what you want to do.
Another way to do this is Conditional Formatting. Go to 'Format' - 'Conditional formatting' and set criteria for what you want to do.
