Conditional formatting from one worksheet to another...

's Computer Specifications

In the first worksheet I have a column entitled Ship Date. In another
worksheet I want only for the column to identify if a ship date is present
with an x. How can I do that? Thank you for your assistance!
Kim

's Computer Specifications

IF['Full Log'!L5>0]THEN[value=x]

The above is what I tried and obviously failed.
Thanks!

"kim" wrote:

> In the first worksheet I have a column entitled Ship Date. In another
> worksheet I want only for the column to identify if a ship date is present
> with an x. How can I do that? Thank you for your assistance!
> Kim

's Computer Specifications

Kim,

Please try:

=IF('Full Log'!L5>"","x","")

"kim" wrote:

> IF['Full Log'!L5>0]THEN[value=x]
>
> The above is what I tried and obviously failed.
> Thanks!
>
> "kim" wrote:
>
> > In the first worksheet I have a column entitled Ship Date. In another
> > worksheet I want only for the column to identify if a ship date is present
> > with an x. How can I do that? Thank you for your assistance!
> > Kim

's Computer Specifications

Hi,

=IF('Full Log'!L5>0,"x","")

Thanks,
--
Farhad Hodjat

"Danny" wrote:

> Kim,
>
> Please try:
>
> =IF('Full Log'!L5>"","x","")
>
> "kim" wrote:
>
> > IF['Full Log'!L5>0]THEN[value=x]
> >
> > The above is what I tried and obviously failed.
> > Thanks!
> >
> > "kim" wrote:
> >
> > > In the first worksheet I have a column entitled Ship Date. In another
> > > worksheet I want only for the column to identify if a ship date is present
> > > with an x. How can I do that? Thank you for your assistance!
> > > Kim

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 with reference to another worksheet VBA	michaelsdumas@gmail.com	Microsoft Excel Programming	4	22nd Jul 2009 09:36 PM
RE: Conditional formatting from one worksheet to another...	=?Utf-8?B?a2lt?=	Microsoft Excel Misc	0	17th Aug 2007 01:48 AM
Conditional formatting from other worksheet	=?Utf-8?B?SG10d25ncmw=?=	Microsoft Excel Misc	3	15th Mar 2007 05:06 PM
Conditional formatting in a worksheet	=?Utf-8?B?QW5keSBTaGFwaXJv?=	Microsoft Excel Worksheet Functions	6	4th Jul 2006 10:25 PM
...Can I copy the Conditional Formatting I have on Worksheet # 1 t	=?Utf-8?B?RHIuIERhcnJlbGw=?=	Microsoft Excel Crashes	1	15th Dec 2005 09:40 PM