| 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 | |||
Linear Mode
