Results 1 to 3 of 3

Conditional Formatting for drop down list

Threaded View

  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

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