the following is a copy of my e mail to you
'thanks very much for the advise you left me on Saturday, the conditional format option appears to be the solution.'
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