I will try again sorry new to the site!
I am using a spread sheet in which I have target dates, I believe there is a method where I can format the sheet so that when the date is reached or passed the colour changes automatically, does anyone have any ideas?:o