+ Reply to Thread
Results 1 to 4 of 4

Change cell's number format based on another cell's value

  1. #1
    Registered User
    Join Date
    11-25-2010
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    9

    Change cell's number format based on another cell's value

    I've been searching around but can't find a way to do this.

    If A1 has a value of 1, I want the format of C1 to change to text. I've seen some similar questions but haven't found an answer that works for this situation.

  2. #2
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Change cell's number format based on another cell's value

    Maybe in the worksheet module
    Please Login or Register  to view this content.

    Hope this helps
    If you need any more information, please feel free to ask.

    However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....

    Also
    اس کی مدد کرتا ہے اگر
    شکریہ کہنے کے لئے سٹار کلک کریں
    If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.

  3. #3
    Registered User
    Join Date
    11-25-2010
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Change cell's number format based on another cell's value

    Thanks for the help Marcol. I thought it might be a VBA solution, and I know nothing about VBA. I've used this in a test workbook and it works perfectly, but I'm wondering what the VBA equivalent of copying down is. I oversimplified in the initial post; I should have said if the value in column A is 1, I need the corresponding cell in column C to change to text.

    For a bit of background: the 1 appears in column A if the name in column B ends in (V), which indicates the person is a visitor (not a member.) Column A is essentially a helper column to determine if the person is a visitor. Visitor's scores don't count for points, and the easiest way I found to have the score ignored in other point-awarding formulas is to change the cell format to text. I have very average Excel skills so maybe I'm not going about this the right way. I'm open to suggestions if there is a simpler way.

  4. #4
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Change cell's number format based on another cell's value

    This might be the VBa solution, it isn't really a "fill down" solution, it is just that the macro is fired by changing any cell/cells in Column A
    Please Login or Register  to view this content.

    However by your description of your sheet, if you put "V" in column A instead of 1 (no need then to add "V" to the visitors' name) then
    Please Login or Register  to view this content.
    will total the members scores
    Please Login or Register  to view this content.
    will total the visitors scores

    No need for VBa

    Hope this helps

+ 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