So then you want A1 to color when you enter a date in B1 and you want C1 to
color when you enter a date in D1?

If that's the case then try this:

Select cells A1 and C1
Conditional Formatting
Formula Is: =ISNUMBER(OFFSET(C1,,1))


--
Biff
Microsoft Excel MVP


"tweets75" wrote in message
...
I will be entering the dates in columns B and D. I tried what you said and
it did not work.

"T. Valko" wrote:

What cell are you entering the date in?

Assume you want to color A1 and C1 when you enter a date in C1.

Select cells A1 and C1
Goto the menu FormatConditional Formatting
Formula Is: =ISNUMBER($C1)
Click the Format button
Select the style(s) desired
OK out

--
Biff
Microsoft Excel MVP


"tweets75" wrote in message
...
I have a list of numbers in columns A and C. I will be entering dates
when
information is received. I want both cells to automatically fill with
color
when I enter the date. I can get the date cell to fill, but not both.
Does
anyone know how to do this?