Hi Charles

Sorry I am very new to code.

I have pasted the code in that you sent me, as requested,But the spreadsheet only color codes as per the sheet I attached.

The workbook as a whole has a lot of code that I have had written through freelancers with some very complicated formulas that are a bit beyond my ability in excel.

But I am slowly working through the issues and learning more and more all the time.

Any further help would be very much appreciated.

Cheers
David