ExcelBanter - Show +/- totals in formulas in green vs. red colors

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Show +/- totals in formulas in green vs. red colors (https://www.excelbanter.com/excel-worksheet-functions/114369-show-totals-formulas-green-vs-red-colors.html)

Daveman

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?

Toppers

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?

Teethless mama

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?

All times are GMT +1. The time now is 06:35 PM.