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?

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

--
Biff
Microsoft Excel MVP


"tweets75" <(E-Mail Removed)> wrote in message
news:14C33567-48D6-4833-884E-(E-Mail Removed)...
>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?

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 Format>Conditional Formatting
> Formula Is: =ISNUMBER($C1)
> Click the Format button
> Select the style(s) desired
> OK out
>
> --
> Biff
> Microsoft Excel MVP
>
>
> "tweets75" <(E-Mail Removed)> wrote in message
> news:14C33567-48D6-4833-884E-(E-Mail Removed)...
> >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?
>
>
>

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


--
Regards,

Peo Sjoblom



"tweets75" <(E-Mail Removed)> wrote in message
news:34692E5B-5C4D-440E-A5C6-(E-Mail Removed)...
>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 Format>Conditional Formatting
>> Formula Is: =ISNUMBER($C1)
>> Click the Format button
>> Select the style(s) desired
>> OK out
>>
>> --
>> Biff
>> Microsoft Excel MVP
>>
>>
>> "tweets75" <(E-Mail Removed)> wrote in message
>> news:14C33567-48D6-4833-884E-(E-Mail Removed)...
>> >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?
>>
>>
>>

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" <(E-Mail Removed)> wrote in message
news:34692E5B-5C4D-440E-A5C6-(E-Mail Removed)...
>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 Format>Conditional Formatting
>> Formula Is: =ISNUMBER($C1)
>> Click the Format button
>> Select the style(s) desired
>> OK out
>>
>> --
>> Biff
>> Microsoft Excel MVP
>>
>>
>> "tweets75" <(E-Mail Removed)> wrote in message
>> news:14C33567-48D6-4833-884E-(E-Mail Removed)...
>> >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?
>>
>>
>>