Are you looking for any situation where a value is entered in the adjacent
cell, or are you wanting to differentiate between date and any other value
type?

If the former,go to Conditional Formatting and set the formula to

=AND(A1="",B1<"")

Substituting current ell for A1 and adjacent cell for B1.

"kelgiar" wrote:

How do I format a cell to fill in with a color if the cell next to it is
filled in with a date and the original cell is not filled in with a date
(Excel 2007)?