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 |