I have conditional Formating in cloum A. It is green and changes to no color when I enter anything into the cell. (Green means that the task has not been addressed and No color means it has). Rather than have to enter the date and time into each cell I would like for the cell to "Auto Fill" the "NOW" date and time when I hit any key or a specific key, like the space bar. I need a formula and I need to know if I need to cancel the Auto formating to use the formula?