change fill color in 2 cells when data entered in one

T

tweets75

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

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
 
T

tweets75

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

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

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