I have attached a spreadsheet and this is what I need. I don’t want the balance at the bottom to acknowledge the deduction till I change their color to black. Can that be done?
I have attached a spreadsheet and this is what I need. I don’t want the balance at the bottom to acknowledge the deduction till I change their color to black. Can that be done?
sorry wrong attachment.
sorry, there is no regular excel formula/function that will recognize formatting. Formatting is a cosmetic that gets applied to a cell, and has no actual value
What might be an alternative would be to, instead of changing the color, in a cell next to the value, enter a number or letter. Then you can use sumifS() to only include that amount if it has been "flagged" by entering something ion the "new" cell
Other than that, perhaps some-one can write some VBA code for you that will give you what you need - but Im thinking that changing color (minimum 1 click) and entering 1 or A (only 2 keystrokes) would be about the same amount of effort for you
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks