Conditional formatting from one worksheet to another...

K

kim

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
 
K

kim

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

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

Danny

Kim,

Please try:

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

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

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

kim said:
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
Click to expand...
Click to expand...
 
F

Farhad

Hi,

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

Thanks,
--
Farhad Hodjat


Danny said:
Kim,

Please try:

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

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

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

kim said:
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
Click to expand...
Click to expand...
Click to expand...
 
Top