+ Reply to Thread
Results 1 to 2 of 2

Drop down menu with highlighted cells

  1. #1
    Registered User
    Join Date
    09-06-2014
    Location
    Chicago, Illinois
    MS-Off Ver
    2007
    Posts
    1

    Drop down menu with highlighted cells

    I just learned how to create a drop down menu in excel 2007, my question is I want to keep track of the right and wrong answers in the drop down options from a different cell. I want to be able to have a drop down menu in B1 and when I select the correct answers in B1 it highlights all of the rest of the correct answers in lets say "B24, B27, B29" while leaving all of the other ones not highlighted.

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Drop down menu with highlighted cells

    How do you know if you selected the correct answer in B1?

    I think we're going to need to see a SMALL sample file that shows us what results you expect.

    SMALL sample file! SMALL!
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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. Replies: 1
    Last Post: 02-07-2013, 11:03 AM
  2. Replies: 3
    Last Post: 01-31-2013, 06:22 PM
  3. [SOLVED] I cant work out how to create a drop down menu that relates to another drop down menu
    By louise2613 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 08-18-2012, 01:49 PM
  4. Replies: 2
    Last Post: 01-30-2009, 04:23 PM
  5. [SOLVED] Drop down menu-How do you produce a drop down menu in a single cell in Excel
    By Freddo in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-04-2006, 04:35 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