I'm not terribly proficient in Excel (i.e. Macros)...but, figure there has to be a way (or certainly should be). I'm working on a budget that I want to determine % spend by specific (color coded) strategy. Tx in advance!
2006-10-29 04:10:56 · 4 answers · asked by l2brennan 2 in Computers & Internet ➔ Software
i'm not sure that you can use colors as a condition in the conditional formatting. I could possibly point you in the right direction as far as setting up an effective budget that will optimize all of your data. Just send me a email if you would like some help on your budget.
2006-10-29 04:51:48 · answer #1 · answered by sweetandprettyinnc 2 · 0⤊ 0⤋
The SumIF function would not replace colours for particular cells it purely returns solutions below a condition. The greater moderen function to SumIF is DSum it extremely is greater versatile (area if Database applications selection). in case you pick for to alter colours for a sort cellular's values, then use conditional formatting and set the cost option to a 'formulation is...'. The source field can save a logical condition that can incorporate applications and different cellular references. This application is discovered from the format menu, Conditional format (Excel 2003). in case you furnish an occasion, then i will make sparkling this added. wish this helped.
2016-11-26 02:05:10 · answer #2 · answered by clance 3 · 0⤊ 0⤋
Click on the cell where you want the answer. Type "=SUM(" then click the first cell you want to total and drag across all the cells you wish to total. Release the drag, Type ")" and press enter.
Note: Do not type the quotes.
2006-10-29 04:16:10 · answer #3 · answered by CHEVICK_1776 4 · 0⤊ 0⤋
If the cells are colored by "conditional formatting" (under format menu), you can use the same condition in "SUMIF" (function). I don't know how to use the color as a condition in SUMIF.
2006-10-29 04:29:46 · answer #4 · answered by novangelis 7 · 0⤊ 0⤋