+ Reply to Thread
Results 1 to 2 of 2

Drop-down lists, data validation

  1. #1
    Forum Contributor
    Join Date
    06-29-2016
    Location
    Bristol, England
    MS-Off Ver
    2007
    Posts
    355

    Drop-down lists, data validation

    Hi

    I am using data validation to control the allowed values for a cell.

    The allowed values are in a named range. There are 2 types of values in the list which I will call 'positive' and 'negative' though these are not numbers, they are text.

    To distinguish them in the named range I set the font colour to red for negative, black for positive.

    When I create the drop-down list all options show up in black.

    I am guessing there is no way of getting the drop-down list to show the colour.??

    I can find a way around this, but does anyone have anything cunning ?

    Thanks

  2. #2
    Forum Contributor
    Join Date
    06-29-2016
    Location
    Bristol, England
    MS-Off Ver
    2007
    Posts
    355

    Re: Drop-down lists, data validation

    PS I use Excel 2007

+ 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] data validation lists - drop down lists too small
    By reglook0736 in forum Excel General
    Replies: 3
    Last Post: 04-24-2015, 12:49 PM
  2. [SOLVED] drop down lists / data validation
    By CashmereCat in forum Excel General
    Replies: 3
    Last Post: 10-11-2012, 12:35 AM
  3. Excel 2008 : Data Validation Drop Down Lists
    By irisorio in forum Excel General
    Replies: 2
    Last Post: 03-02-2011, 09:46 PM
  4. Data Validation - Drop Down Lists
    By Guzziguy in forum Excel General
    Replies: 2
    Last Post: 06-04-2009, 03:24 PM
  5. data validation and drop down lists
    By LewR in forum Excel General
    Replies: 3
    Last Post: 03-14-2006, 02:55 PM
  6. data validation - Drop Down Lists
    By Annie in forum Excel General
    Replies: 8
    Last Post: 07-28-2005, 09:05 PM
  7. [SOLVED] Data Validation - Drop down lists - if then?
    By Steve R in forum Excel General
    Replies: 2
    Last Post: 04-08-2005, 02:06 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