+ Reply to Thread
Results 1 to 3 of 3

Help with cell actions based on other cell content

  1. #1
    Registered User
    Join Date
    01-30-2013
    Location
    peterborough, england
    MS-Off Ver
    Excel 2003
    Posts
    2

    Help with cell actions based on other cell content

    Please see attachment

    Many years ago I created the data in the attached spreadsheet but I have now forgotten how I created it and I would like to add it to a another worksheet.

    If you type text in A5 the text will appear in B5 but only if certain conditions are met in the cells above.

    Appreciate it if any one could remind me how I did it.

    Thanks ... Dennis
    Attached Files Attached Files

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,481

    Re: Help with cell actions based on other cell content

    Your example has no data in. I don't know exacly what you mean.
    Anyway, as per your describing, may be :
    B5=IF(conditions are met,A5,"")
    Quang PT

  3. #3
    Registered User
    Join Date
    01-30-2013
    Location
    peterborough, england
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Help with cell actions based on other cell content

    Thank you for your reply.

    Sorry I should have made myself more clear, by data I meant the formulas or conditional formatting that I have used to make cells A5 and B5 work. Both A5 and B5 appear to be blank cells with no conditional formatting but if you type text in A5 a formula appears in B5 which is =A5.

    I am asking for help to find out how I have done that.

    Thanks ... Dennis

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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