The cell is manually turned green. I go through and adjust the cells that I want to always be 0. I update the spreadsheet monthly, and most cells that start green, stay green each month. I just overwrite the "B4" value in the example several times a day for the first week of the month as prices come in. Since there are 20-30 cells that will always be 0, regardless of what price comes in, I am trying to determine an easy way to force them to 0 without manually adjusting all of them.