Conditional formatting from one worksheet to another...
Thanks Danny! When I tried it still no luck but when I put in a date I was
golden! =IF('Full Log'!L501/01/1900,"X","") You're the best! Thanks again. Kim "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 |
All times are GMT +1. The time now is 11:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com