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.