Conditional Formattng

Hi I am looking or help.

I need to formate a cell based on the value of another ie if the cells says Y=yes then i need the date cell to auto populate todays date.

also i am trying to create an ID field in excell that when a new record is added is addes new id ie 1,2,3, etc can anyone help with either of these.

i HAVE TRIED THIS AND IT DOES NOT APPEAR TO ENTER ANY DATA INTO THE DATE CELL. SO IF I PRESS Y FOR YES I NEED THE DATA CELL TO AUTO POP WITH THE DATE & OR TIME

Have you tried

Please Login or Register  to view this content.

?

Hi this works fine but what I am noticing is that every day I open the form up to add records the date that the call was originaly raised on 04/08/14 has changed to the current date.

What I need it to do is when I press yes it puts the current date in and stores it so when I open it up after a couple of days or weeks I need it to still show the date that it was originaly dispatched not the date that I am opening it up on.