+ Reply to Thread
Results 1 to 5 of 5

need correct formula to determine which cells to format

  1. #1
    Registered User
    Join Date
    11-18-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2003
    Posts
    5

    need correct formula to determine which cells to format

    Hi, I'm linking two workbooks together, namely a column in one workbook that is linked to another column. The source column is populated with dates although some cells are blank. My problem is when I link this via a Paste Link set up, where the blanks occur in the source excel doc it copies over as 0/01/00 instead of a blank cell to my destination workbook. Does anyone know the formula to correct this so that blank cells stay as blank cells in the column? Hope this makes sense. Thanks.

  2. #2
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: need correct formula to determine which cells to format

    not sure how you are doing this, but if your using a formula, maybe something like this
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Hope this helps
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post

  3. #3
    Registered User
    Join Date
    11-18-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: need correct formula to determine which cells to format

    thanks, I'll give it a go.

  4. #4
    Registered User
    Join Date
    11-18-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: need correct formula to determine which cells to format

    It worked!!! thanks

  5. #5
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: need correct formula to determine which cells to format

    You are welcome !

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Conditional Formatting to Use a formula to determine which cells to format
    By kenadams378 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-16-2013, 10:29 AM
  2. [SOLVED] CF - using a formula to determine which cells to format...ISSUE
    By AMSBenji in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-02-2013, 08:43 AM
  3. Replies: 3
    Last Post: 08-04-2012, 07:22 PM
  4. Use a formula to determine which cells to format?
    By jonvanwyk in forum Excel General
    Replies: 4
    Last Post: 06-04-2012, 11:10 AM
  5. [SOLVED] A formula or macro that determine the correct month
    By leitek.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-07-2006, 04:40 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1