+ Reply to Thread
Results 1 to 1 of 1

Conditional Format:Entry looks to mult. ranges to highlight many cells

  1. #1
    Registered User
    Join Date
    11-29-2007
    Posts
    20

    Conditional Format:Entry looks to mult. ranges to highlight many cells

    Hi, I'm working on a calender that will highlight biweekly dates based on which range of data it finds the user defined entry in A2.
    For Example: I would like to put in code AHH in cell A2 and it look in range A13:B17 and D13:E17 and G13:H17 and highlight the cells of a calendar based on which range AHH was found in. (If AHH is entered in A2, The first and third Friday of the calendar will shade light green.)
    I would like it not to matter if the some of the cells in the range are empty. The different ranges will also be on different sheets.

    The worksheet attached is just to give an example. The actual worksheet is at work using Excel 2003 and has the entire year.

    PS. Would anyone know how I can set up the calendar so it updates itself for each new year?

    Thanks for looking.
    Attached Files Attached Files

+ 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