Results 1 to 3 of 3

Locate Item and color it

Threaded View

  1. #1
    Forum Contributor Bob@Sun's Avatar
    Join Date
    09-03-2009
    Location
    Montuak, Usa
    MS-Off Ver
    Excel 2007
    Posts
    438

    Locate Item and color it

    Hi,

    I need help for a macro that will do the following:

    Set Month = Sheets(“Sheet1”).Range(“AI5”)
    Set Item = Sheets(“Sheet1”).Range(“AI6”)
    Set Dates = Sheets(“Sheet1”).Range(“AI7”)
    Locate the cells on the Sheet and Color them.

    So in my example the macro must find P3 and Q3 and color them

    I count on your help

    Thanks in advance!
    Attached Files Attached Files
    Last edited by Bob@Sun; 02-14-2010 at 08:45 AM.

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