Hi Everyone,

I am having problems trying to do something, when it seems so simple.

I have two excel files. One excel file has all the date values and th
other excel file, link to cells from the first excel file. The cells i
links to are date values. I can the 2nd file to the first file. Not
problem. But some problems are occuring.

For example, if I don't have a date value in the first file I get th
value 1/11/1900, which I don't get why that is there?

Also, after I get the date value, I want to compare it to anothe
value, then set the cell to a particular color. So if the date in th
first file cell is 10/15/04 and the due date was suppose to b
10/14/04, the cell gets turned to red. I hope that makes sense.

I will really appreciate any help in this. Thank you

--
LongBeac
-----------------------------------------------------------------------
LongBeach's Profile: http://www.excelforum.com/member.php...fo&userid=1539
View this thread: http://www.excelforum.com/showthread.php?threadid=27005