Conditional formatting again

's Computer Specifications

I have anticipated ship date in workbk 'Full Log'!K5
I want anticipated ship date in 'Sub Log'!F5
When I put in formula ='Full Log'!K5 and there is no value in the column, I
get 01/0/1900 and I don't want that I would prefer for it to be blank for the
people who are looking at the information are becoming confused. How can I
do it?

's Computer Specifications

Once again Danny to the rescue!
Thanks!

"kim" wrote:

> I have anticipated ship date in workbk 'Full Log'!K5
> I want anticipated ship date in 'Sub Log'!F5
> When I put in formula ='Full Log'!K5 and there is no value in the column, I
> get 01/0/1900 and I don't want that I would prefer for it to be blank for the
> people who are looking at the information are becoming confused. How can I
> do it?

's Computer Specifications

Kim,

You can try it with an IF function:

IF('Full Log'!K5="","",'Full Log'!K5)

"kim" wrote:

> I have anticipated ship date in workbk 'Full Log'!K5
> I want anticipated ship date in 'Sub Log'!F5
> When I put in formula ='Full Log'!K5 and there is no value in the column, I
> get 01/0/1900 and I don't want that I would prefer for it to be blank for the
> people who are looking at the information are becoming confused. How can I
> do it?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting of text effecting formatting of background	=?Utf-8?B?SEFI?=	Microsoft Access Reports	6	25th Mar 2008 06:23 PM
Protect Cell Formatting including Conditional Formatting	=?Utf-8?B?TWljayBKZW5uaW5ncw==?=	Microsoft Excel Misc	5	13th Nov 2007 05:32 PM
Conditional Formatting No Longer Conditional in 2007 Beta	=?Utf-8?B?Q2FjdHVhci1Oby1KdXRzdQ==?=	Microsoft Excel Crashes	0	17th Nov 2006 10:01 PM
How do I do a complex conditional in a conditional formatting formula	Ray Stevens	Microsoft Excel Discussion	7	12th Mar 2006 10:24 PM
Conditional Formatting that will display conditional data	=?Utf-8?B?QnJhaW5GYXJ0?=	Microsoft Excel Worksheet Functions	1	13th Sep 2005 05:45 PM