You get this because the background is yellow, so the answer is true.

On the dropdown list, verify that Automatic is selected.

When this option is set to automatic, Excel recalculates the spreadsheet’s formulas whenever you change a cell value.

But you could simply replace this part with whatever calculation you want to run depending on whether it is true or false.

Step 1 First of all we need to create a custom Excel function.

Next step is to get the numerical value of a background colour.

It is important to note here that when typing the formula we will be referencing a cell by its numerical value, for example, 4,4 instead of D4.

Can you check and make sure the data in there is all still numerical?

I think I've noticed this happening for me when I threw in a value once that was "$xyz" as opposed to "xyz" (I mean xyz to be some integer, of course). I suggest you copy your formula into Notepad, then type any number into the cell.

This means that, if you have a formula that totals up your sales and you change one of the sales, Excel updates the total to show the correct sum.