Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sum in colors
Hi;
I am in the process of building a home and i would like to keep a running total of the expenses vs the budget we have set. Can i make a formula that will total in green if under budget, red if over budget and black if on budget? Thanks Do |
#2
|
|||
|
|||
sum in colors
You can use Conditional Formatting on the Format menu to do this.
"D" wrote in message ... Hi; I am in the process of building a home and i would like to keep a running total of the expenses vs the budget we have set. Can i make a formula that will total in green if under budget, red if over budget and black if on budget? Thanks Do |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Modify the default graph colors | Charts and Charting in Excel | |||
Can I modify Excel 2003 color palette to accept Pantone colors? | Excel Worksheet Functions | |||
custom cell pattern colors | Excel Worksheet Functions | |||
How to add fill colors (cell shading) in EXCEL? | Excel Discussion (Misc queries) | |||
How do I get custom colors for filling cells in Excel? | New Users to Excel |