Lets say that you have the date 25th of September i cell A1.
On 29th of December cell A1 is green.
On 30th of December cell A1 is still green.
On 31th of December cell A1 turns red.
On 1st of January cell A1 is still red.
On 2nd of January cell A1 is still red.
Then a new date is entered in cell A1.
If the new date is before 25th of September, what will happen to the
color?
If the new date is Sept 26th, Sept 27th, Sept 28th, Sept 29th, Sept
30th, Oct 1st, Oct 2nd, ...., December 30th, December 31st, Jan 1st,
Jan 2dn, Jan 3rd - I all these cases, "a new date is entered into
cell A1". Does it mean that it should turn green in all these cases?
I guess there are some "built in" conditions on which type of dates
that can be entered into A1 that you know of but is not obvious if you
don't what these dates are used for. Maybe entering a "new date"
always mean that you enter todays date, or a later date than before,
but not neccessarily much later. It could still be a quite "old" date.
Lars-Åke