Conditional formatting from one worksheet to another...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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...
 
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...
 
Back
Top