Help with Spreadsheet

Hi
I am new to VB etc but have some knowledge of Excel. I will try and explain what I need and hopefully someone can help. I have a tracker spreadsheet. I have a Days Cell and a Date Received cell...when a date is entered into the date received cell then traffic light comes up and starts counting how many days this case has been open for. When a case is closed I want to enter a date in another colum (released) and this will then delete the Days cell contents. I managed to do it with one row but I want this to be active on all rows...hope that makes sense?

Hi

Sorry, as I have said a bit new to all this so apologies.

I have attached the same spreadsheet and hopefully this will help. Basically when a date is added in the B coloum a traffic light comes up counting the days and I want this to be removed should a date be added to colume E.

Does that make sense?

Good Afternoon,
Thank you so much for your help.
Kind Regards
Amy