I have been trying to conditionally fomat columns based on wether or not a date of a percentage has been entered in a cell. Currently I have one column where a precentage complete is entered, or a completion date. I used a formula given to be from a previous post to sum inches complete from another cell based on what was entered in this cell, generally the numbers entered in these cells are origionally entered as percentage complete, and then changed to completion date once complete. I would like to be able to enter a date without having to manually change the format each time.