change fill color in 2 cells when data entered in one

[Guest]

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?

 

[T. Valko]

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 Format>Conditional Formatting
Formula Is: =ISNUMBER($C1)
Click the Format button
Select the style(s) desired
OK out

 

[Guest]

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

 

[Peo Sjoblom]

Then you are not entering what Excel sees as dates, all dates in Excel that
can be used to calculate or compare with needs to be numeric like 07/10/07
but not for instance July 10 2007

 

[T. Valko]

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))