Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting from other worksheet | Excel Discussion (Misc queries) | |||
Conditional formatting for shared worksheet? | Excel Worksheet Functions | |||
Conditional formatting in a worksheet | Excel Worksheet Functions | |||
Conditional formatting is unavaiable in worksheet, what can I do? | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |