Results 1 to 2 of 2

Conditional formatting for partial number match.

Threaded View

  1. #1
    Registered User
    Join Date
    11-29-2010
    Location
    Nashville
    MS-Off Ver
    2010
    Posts
    76

    Conditional formatting for partial number match.

    I'm working on a manual entry on a large document where it will be easy for me to make mistakes if I don't do some highlighting. Here's what I want:

    If the first 6 digits of two numbers match, I want to highlight #A:#K of that row.

    The numbers are located in Column E, and I'd like to do this all in conditional formatting formula, not adding another cell.

    __A B C D E_________ F G H I J K
    1 -------------7949460047 - - - - - -
    2 -------------7949460054 - - - - - -
    3 -------------7868150025 - - - - - -
    4 -------------7950430020 - - - - - -
    5 -------------7950170071 - - - - - -
    6 -------------7950170139 - - - - - -
    7 -------------7950170048 - - - - - -
    8 -------------7950170097 - - - - - -
    9 -------------7950170147 - - - - - -

    So in this example, highlighting should happen 1A:2K, 5A:9K

    Thanks for your help!
    Last edited by SymphonyTomorrow; 12-02-2010 at 02:50 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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