Conditional formatting from one worksheet to another...
 

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

Conditional formatting from one worksheet to another...
 

IF['Full Log'!L50]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

Conditional formatting from one worksheet to another...
 

Kim,

Please try:

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

"kim" wrote:

IF['Full Log'!L50]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

Conditional formatting from one worksheet to another...
 

Hi,

=IF('Full Log'!L50,"x","")

Thanks,
--
Farhad Hodjat


"Danny" wrote:

Kim,

Please try:

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

"kim" wrote:

IF['Full Log'!L50]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