+ Reply to Thread
Results 1 to 2 of 2

Conditional formatting referencing 2 sheets

Hybrid View

  1. #1
    Registered User
    Join Date
    01-02-2011
    Location
    Dubai, UAE
    MS-Off Ver
    Excel 2007
    Posts
    2

    Conditional formatting referencing 2 sheets

    hi
    i have 3 sheets one with data 1, data 2 and the other main.
    the workbook is mainly bout students grades, and the courses they are taking.
    data 1 consists of courses that have been taken by the student before n their grades.
    the data 2 consists of column A being the students ID and column B being the course id.

    i need excel to highlight the course id on the main sheet after referencing student id and course from data 2.

    for example ACC410 is current being taken by student id 90012154, i need the course ACC410 on the main sheet to be highlighted in yellow text with yellow background.

    another thing i wanted to kno is how can i filter out the courses that are present in the tables from the ones present in data 1 and data 2.
    i need to show the grades of the courses that have been taken and the courses currently enrolled in by the student other than the ones displayed on the main sheet.
    Attached Files Attached Files

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Conditional formatting referencing 2 sheets

    Hello Phosu,

    Welcome to the Forum!

    Your layout is a bit confusing. It would help if you added a sheet showing the desired results.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

+ 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