Huge thanks to @iCFO for this solution - good work, thank you.
To get the outcome I was looking for I created a template and applied conditional formatting to the relevant cells. I then saved the blank file and used it as the template.
@Unlockedata no problem at all. Glad you had very good suggestions from different contributors and eventually a satisfactory solution. I learnt a lot myself frm this thread !