Having looked through the list a number of times you still can't find where the problem is. What is more you do this every week and it's wasting time. Conditional formating can change the colour of a cell based on the data that is in it. This online IT training video will show you how.
You may have to click on enable editing in Excel to be able to complete the exercise.