+ Reply to Thread
Results 1 to 3 of 3

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

  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

  2. #2
    Forum Contributor
    Join Date
    08-04-2014
    Location
    Riga
    MS-Off Ver
    2010
    Posts
    579

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

    You need to set up 8 additional rules in Conditional formatting - one rule for each color. Select the rule to be based on a formula. For example =C4=$T$3, then =C4=$T$4 and so on. Put these rules only in C4, then click OK to close Conditional formatting. Select C4 and use Format Painter to apply the rules to all other cells.

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

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

    Thanks. I had hoped there was a way to apply directly based on the named range properties. Appreciate the help.

    Regards,
    Lee.

+ 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. 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