+ Reply to Thread
Results 1 to 3 of 3

EXCEL 2003 Changing row colour based on drop-down selection - more than 3 conditions

  1. #1
    Registered User
    Join Date
    02-10-2011
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    11

    EXCEL 2003 Changing row colour based on drop-down selection - more than 3 conditions

    I have a drop-down list in a cell that contains 6 items (for arguments sake named Item 1, Item 2, Item 3, Item 4, Item 5, Item 6). I would like the whole row to change colour depending on what Item was selected: it would change to Blue if Item 1 were selected; Green if Item 2 selected and so on.

    I am aware that I may need to have a 'Select Case' in VB to list the items along with the colour index numbers alongside, for the 6 listed Items.

    Many thanks for taking your valuable time to read this and any help much appreciated.

    Paul S

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: EXCEL 2003 Changing row colour based on drop-down selection - more than 3 conditi

    Post up a small workbook showing the exact data layout and all of the colors/values associated. 10-20 rows should be sufficient.

    This solution will involve VBA. I will be recommending a Worksheet_Change() event active on the sheet that does this for you in realtime as you change the the values in that particular column.

    Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    02-10-2011
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: EXCEL 2003 Changing row colour based on drop-down selection - more than 3 conditi

    *** SOLVED ***

    Apologies for not replying sooner. I managed to solve the problem via another forum.

    Thanks for taking the time to read.

+ 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