Hi,
I have a budget spreadsheet. Each month, users are able to change the interior fill (Green = ok, Yellow = monitor, Red = bad). The spreadsheet has multiple column (B10:E79) and totals on row 80 for each column. On row 82 in each column I wish to have a total for all the green filled cells, row 83 for the yellow filled cells, and row 84 for the red filled cells. Each month, when the interior fill changes, the totals in rows 82, 83, and 84 need to be automatically updated.
I know Excel does not consider changing a cell's color to be significant to the calculation; thus, won't recalculate a formula when a cell color is changed. Simply changing a cell color does not cause a calculation, so the function is not recalculated, even with Application.Volatile True. Knowing this, how can I get the totals in rows 82, 83, and 84 need to be automatically updated each time the fill color changes? Assume the Color Index is green=4, yellow = 6, red = 3) if that helps.
Suggestions? Thanks for your help!
Bookmarks