+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting for drop down list

  1. #1
    Registered User
    Join Date
    04-29-2019
    Location
    Hampshire, England
    MS-Off Ver
    2018
    Posts
    43

    Conditional Formatting for drop down list

    Is it possible to use conditional formatting on a drop down list so it shows the text in a specific colour depending on a value on a separate sheet where the data is obtained from and already conditioned?

    E.g. The fruit on the ‘Fruit tab’ is associated a number 1-3 which corresponds to a colour 1=red, 2=amber and 3=green. So when it is changed to another number between 1 and 3 the colour of the text change with it.

    How can I get the text in the drop down list to maintain these conditions on the 2nd sheet when it is selected from the drop down list and updated if the number were to be change on the ‘Fruit tab’?
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,531

    Re: Conditional Formatting for drop down list

    You can add conditional formatting rules on the Final sheet that mirror the rules on the Fruit sheet. You have to use a formula that takes the fruit selected in column B and look it up on the first sheet to find the score, then use that for conditional formatting just like you did on the first sheet.

    Note: This colors the result of what the user selected. It does not color the items in the list itself.

    Implementation attached.
    Attached Files Attached Files
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Conditional Formatting for drop down list

    One way would be with a helper colums - say A in the Final SHeet with the formula

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    in A2 copie down

    Then the three CFs in B2 and applied to all the column B cells are

    =$A2=1 -format as red
    =$A2=2 - format as yellow
    =$A2=3 - format as green

    see attached
    Attached Files Attached Files
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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. [SOLVED] Can't Get Drop List To Cooperate With Conditional Formatting
    By pahickham in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-12-2017, 11:04 AM
  2. Conditional Formatting with Drop Down List
    By beneesetas14 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-29-2015, 11:41 PM
  3. Drop Down List & Conditional Formatting
    By beneesetas14 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-29-2015, 12:34 PM
  4. Replies: 0
    Last Post: 06-03-2014, 04:21 AM
  5. [SOLVED] Using conditional formatting on a drop down list
    By scottatbuckman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-13-2014, 02:07 PM
  6. Replies: 4
    Last Post: 08-25-2009, 06:00 PM
  7. using Conditional Formatting on a cell with a drop down list
    By Rabbit84 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-24-2009, 05:34 PM

Tags for this Thread

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