Green Marks inside Excel cells

A visitor asked

I have refined the spreadsheet you done earlier so that each meal calculates the percentage of fats, carbohydrates, and proteins.  It also does the same for the totals at the end of the day.  But I notice there are green marks inside some of the bottom cells.  Why?

Updated- Read more about the green triangles in Excel and how to remove, use and customise them.

These are some error checks that have been built into Excel. If you hover over the green mark and click on the drop down that appears it will say something like “Inconsistent Formula”. This means that Excel has identified that the cells in this area have a common structure and this cell is different. It does not mean that it is wrong, it is just a warning.

You can switch this feature on and off in the Options sections.

Below how you can use them to convert numbers that Excel confuses as text back into numbers


Edit with arrows keys not working in Conditional Formatting