+ Reply to Thread
Results 1 to 4 of 4

how to i find and mark multiple cell in sheet and also colored same seleced cell....

  1. #1
    Registered User
    Join Date
    10-12-2013
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    14

    how to i find and mark multiple cell in sheet and also colored same seleced cell....

    hi all,

    I have big library books database file. now i want to re check all the book with physical stock and mark in excel file.

    i have one more file with books barcode no.

    now i want to mark multiple cell in sheet..

    can u help me out

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: how to i find and mark multiple cell in sheet and also colored same seleced cell....

    Not sure what do you mean by the word mark??


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    10-12-2013
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: how to i find and mark multiple cell in sheet and also colored same seleced cell....

    i have one big library books record file with 40000 record.

    now i have one new file with updated isbn no list.

    now i want to update (cross check) my old file and with new file of isbn no.

    no i do, find isbn no in old file and do color or row.

    can you give me some easy idea.....

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: how to i find and mark multiple cell in sheet and also colored same seleced cell....

    Make use of Vlookup Function.

    Just do a google search about Vlookup function you will get lot of materials with clear explanations about how to use it.

    After that apply auto filter to the arrived result and color it...

+ 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] Find first and last cell of colored range and put in data
    By moosmahna in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-21-2013, 06:26 AM
  2. [SOLVED] Find certain text in a cell and mark it as...
    By siobeh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-29-2013, 12:28 PM
  3. Replies: 2
    Last Post: 03-13-2012, 09:02 AM
  4. Find cell and mark area in relation to the cell
    By ChrisNor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-17-2009, 04:59 AM
  5. Find and mark cell
    By hafizfarooq in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-17-2008, 05:24 AM

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