| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Show +/- totals in formulas in green vs. red colors
Can someone advise me on how to setup the sum of a formula to be shown as
"Red for negative and/or Green for positive" totals? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Show +/- totals in formulas in green vs. red colors
Try:
CUSTOM format as: [Green]#,##0;[Red]-#,##0 HTH "Daveman" wrote: Can someone advise me on how to setup the sum of a formula to be shown as "Red for negative and/or Green for positive" totals? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Show +/- totals in formulas in green vs. red colors
Try Conditional Formatting
"Daveman" wrote: Can someone advise me on how to setup the sum of a formula to be shown as "Red for negative and/or Green for positive" totals? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| having trouble creating chart to show monthly totals | Charts and Charting in Excel | |||
| PivotChart, How to show Grand Totals in the chart? | Charts and Charting in Excel | |||
| How do you show formulas in certain cells only (not the whole she. | Excel Worksheet Functions | |||
| UDF and Calculation tree | Links and Linking in Excel | |||
| How do I show summary totals from a pivot table on a bar chart | Charts and Charting in Excel | |||
Hybrid Mode
