Results 1 to 3 of 3

Apply formatting from named range items during data validation (pull down list)

Threaded View

  1. #1
    Registered User
    Join Date
    08-16-2011
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    13

    Apply formatting from named range items during data validation (pull down list)

    Hello. I'm trying to create a leave planner. Could you help me to understand how I apply the same colour fill, as per the same item in the named range 'Leave type', to the cell where I am selecting from the pull down list?
    I.e. If I select 'AL - Full Day' from the pull down list in cell C4, I would like the cell to become orange filled as per the same item in the named range. As always, any help is much appreciated.

    Regards,
    Lee.
    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. Edit Named Range for Data Validation List
    By RxMiller in forum Excel General
    Replies: 1
    Last Post: 08-31-2011, 10:17 PM
  2. Named Range - Data Validation List
    By Tarball in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-28-2010, 12:34 PM
  3. Dynamic Named Range inside a Data Validation list ?
    By Richard in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-11-2006, 10:00 AM
  4. Replies: 0
    Last Post: 11-24-2005, 10:29 AM
  5. Replies: 1
    Last Post: 06-24-2005, 12:21 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