Auto update date

[Lewy]

i have a training spreadsheet with conditional formatting and a drop down
list, would it be possible to put the date in the reference cell for the drop
down and for this date to auto update itself without affecting the actual
cell on the training sheet. Many thanks for any help with this question.

 

[Lewy]

Yes that is correct Dan

Let me understand, you want the drop down to default to the current
date but once a date has been selected you don't want that to be
updated, is that correct?

Sorry if I'm misunderstanding....

Dan

 

[Lewy]

Thanks for getting back to me Dan, this is my layout,
A B C D I
Tasks Mark Billy John Drop list ref
Open bag Level 1 Level 2 Level 3 Drop list ref

Drop list ref
The list of tasks go down col A 2 to A 20, Names across the top B1 to B7 and
B2 to G20 has a drop list in each cell, the reference cells for my drop list
is in I 2, I 3, I 4,
in my ref cells are Level 1, Level 2, Level 3, I would also like the date to
go in the ref cells, so that when i update the persons Level the date goes in
aswell as the Level, i need the ref cell date to auto update itself and when
inserted to a person to stay at the same date as when it was entered. I hope
this is a more clear explanation Dan thanks for your help thus far and i hope
you can help some more, much appreciated. Lewy

 

[Lewy]

This works as far as putting the date in the ref cell with the text already
in there, i had to put some dashes in after my text to seperate the text and
date as my text had a number at the end and it looked like Level 112/09/09 it
now looks like Level 1---12/09/09
I will let you know if the date in either the ref cell or in the destination
cell causes any problems but once again thank you Dan, this makes life quite
a bit simpler for me, much appreciated mate.

 

[Lewy]

As far as the date entry goes it works spot on Dan but when the date in the
reference cell changes i loose the conditional formatting colour in my main
cells, any thoughts, thanks Lewy.

 

[Lewy]

Dan these are the formatting rules in use, if it makes a difference i am
using excel 2007 at home but 2003 at work, the one at work is the main one i
want to work.
Format only cells with specific text containg Level 1
Format only cells with specific text containg Level 2
Format only cells with specific text containg Level 3
The format above colours each cell according to its level, and the one below
colours the persons name when all their tasks are at level 1.
=AND(B2="Level 1",B3="Level 1",B4="Level 1",B5="Level 1",B6="Level
1",B7="Level 1")
Thanks again Dan