Private data_range As Variant Private Paid_Total As Integer Private cell_in_loop As Variant ' data_range being the selected cells to sum if the criteria match.Function Sum_Colour(data_range) Paid_Total = 0 For Each cell_in_loop In data_range If cell_in_loop. Color Index = 35 Then Paid_Total = Paid_Total cell_in_loop.
If the values in the cells change then excel will reclaculate - it seems as though Excel does not recalculate after a formatting change. See: note what he says: NOTE: When you change the background or font color of a cell, Excel does not consider this to be changing the value of the cell.
Three attempts later and it was still adamant it wanted to be "Manual" and nothing else.
Copy the contents of the spreadsheet to a new one, and deleted the old one (it wasn't a particularly important spreadsheet, thankfully), and everything was fine.
You check if a donut chunk went in to the key board and some how jammed the ENTER key. When you do it, excel shows the formulas instead of their results.
The formula shows up in the cell instead of the result, like this: Now what to do? You may have accidentally pressed CTRL ` (back quote symbol, the key below escape key in your keyboard) or activated the “Show Formulas” mode in Excel.