Conditional formating dates

gurus,


I am trying to conditionally format a cell that when a date is entered, the cell is filled green. However, if the cell does not contain a date it should be no fill. Meaning, if the user enters a hyphen or NA in the cell, I don't want the cell to format to green.

Unfortunately in my sample spreadsheet, when a hyphen or even NA is entered in the cell, the cell fill is set to green. I cannot figure out the formula that only sets the fill to green when a date is entered.

I understand that excel translates dates to numbers, but I don't understand why a hyphen or even NA is also triggering the fill setting.

I have tried a couple of formulas in my sample to no avail. Please help and show my what I am doing wrong.

TIA,
Tim

AlKey,

I followed your instructions but it didn't seem to work.

Tim

Alkey,

I found that the statement "select the column" was incorrect. I had to select the cells within the column, not the whole column. That was where the confusion was.

Anyway, it works now. I had added a few other conditions in order for it to work the way I wanted it to.

Thanks for pointing me in the right direction!

Tim

All,

Please use this example.

Tim