+ Reply to Thread
Results 1 to 4 of 4

Highlights Numbers (which are in text)

  1. #1
    Registered User
    Join Date
    11-22-2010
    Location
    sg
    MS-Off Ver
    Excel 2003
    Posts
    3

    Highlights Numbers (which are in text)

    hi

    I've saved a list of numbers as text because i need the "zero" to appear in front.

    Are there any ways to identify numbers in their same permutations.

    E.g. I've "025" in column A, "250" in column B, "502" in column C, i want all these info to be highlighted automatically whenever i key in new info with these same group of numbers. is it possible in Excel?

    Thanks very much for the help, i really hope someone will be able to solve this.

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Highlights Numbers (which are in text)

    Hi moody,


    Are there only 3 digit numbers in the list?
    Is this mandate to have all the 3 digits to appear? i.e., what if we have 5023 in the list which has the required 3 digits plus one digit extra?

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Registered User
    Join Date
    11-22-2010
    Location
    sg
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Highlights Numbers (which are in text)

    thanks for showing interest,

    there will only be 3 numbers in my list.

    any clue?

  4. #4
    Valued Forum Contributor
    Join Date
    07-29-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2003/Excel 2010
    Posts
    534

    Re: Highlights Numbers (which are in text)

    See attachment, the conditional format in column A should do what you're looking for, if i understand correctly.

    Edit: updated attachment at 11:56
    Attached Files Attached Files
    Last edited by WHER; 02-20-2012 at 06:56 AM.

+ 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