+ Reply to Thread
Results 1 to 2 of 2

Highlighting cells via a DropDown

  1. #1
    Registered User
    Join Date
    09-05-2014
    Location
    Middle of the US
    MS-Off Ver
    Excel 2010
    Posts
    3

    Highlighting cells via a DropDown

    I have created a Drop Down list that has values of Pass and Fail. When the user selects the appropriate value, I would like to have PASS highlighted in Green and FAIL highlighted in Red. Is this possible? I tried highlighting them in the list that was used to create the dropdown, but the highlights did not follow through to the drop down. Thanks in advance.

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Highlighting cells via a DropDown

    Data Validation does not read the format of the source cells.
    You probably want to try using Conditional Formatting...
    • Select the DV cells to be formatted (assuming B2:B20, with B2 as the active cell)
    • Home.Conditional_formatting...New_Rule
    ...Check: Use a formula to determine which cells to format
    ...=B2="Pass"
    ...Click the Format button...set the format you want for "Pass"
    ...Click: OK...Click: OK
    ...Click: New Rule
    ...Check: Use a formula to determine which cells to format
    ...=B2="Fail"
    ...Click the Format button...set the format you want for "Fail"
    ...Click: OK...Click: OK..Click: OK

    Done


    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

+ 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: 13
    Last Post: 03-28-2014, 12:45 AM
  2. [SOLVED] Highlighting Cells if Specific Data Appears in Adjacent Cells
    By vinceancona in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-18-2014, 06:33 PM
  3. Replies: 2
    Last Post: 02-06-2013, 12:13 AM
  4. Highlighting a range of cells dependant on data in any of those cells
    By Grimace in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-20-2009, 02:34 AM
  5. Replies: 6
    Last Post: 08-28-2005, 05:05 PM

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