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.
Use the if function file for the conditional formatting exercise.
You may have to click on enable editing in Excel to be able to complete the exercise.
At Computer Tutoring, we prioritise your privacy and only collect the necessary information to provide our services. We will only share the personal data you provide in a form if you have opted in for those services. Our website also uses Google Analytics. You have the right to access, amend, or request deletion of your personal data by contacting us at info@computertutoring.co.uk.
For more details, please read our full Privacy Policy.