change fill color in 2 cells when data entered in one
 

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?

change fill color in 2 cells when data entered in one
 

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?

change fill color in 2 cells when data entered in one
 

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?

change fill color in 2 cells when data entered in one
 

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" 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?

change fill color in 2 cells when data entered in one
 

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?