Results 1 to 13 of 13

Conditional formatting doesn't work for Drop Down List containing Custom Number Format

Threaded View

  1. #1
    Registered User
    Join Date
    03-14-2016
    Location
    toronto, canada
    MS-Off Ver
    2007
    Posts
    5

    Conditional formatting doesn't work for Drop Down List containing Custom Number Format

    Hi,

    I created a list containing number values and format them to text.

    I then created a drop down list for a cell using this first list.

    I want this cell format to change based on the original number selected.

    For some reason it doesn't work. I have attached the file here.

    Thanks in advance for sharing your ideas.

    Best,

    R

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 02-28-2014, 07:12 AM
  2. Updating a pivot table with VBA from Drop down list (1st item doesn't work)
    By tray262 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-25-2013, 02:32 PM
  3. Conditional Formatting doesn't work after copy and insert
    By amarus99 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-01-2012, 02:52 PM
  4. Excel 2007 : AND doesn't work in Conditional Formatting
    By cellarir in forum Excel General
    Replies: 2
    Last Post: 03-21-2012, 06:10 PM
  5. VBA code for (un)hide columns related to drop down list doesn't work
    By maumon in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-21-2010, 08:27 AM
  6. Replies: 3
    Last Post: 09-09-2009, 03:35 PM
  7. [SOLVED] Custom Time Format doesn't work for me
    By chuck in forum Excel General
    Replies: 1
    Last Post: 02-13-2005, 01:06 AM
  8. Replies: 0
    Last Post: 02-10-2005, 02:46 AM

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