+ Reply to Thread
Results 1 to 4 of 4

Grey out areas when i select dates from a drop down

  1. #1
    Registered User
    Join Date
    11-18-2009
    Location
    England
    MS-Off Ver
    Excel 2016
    Posts
    88

    Grey out areas when i select dates from a drop down

    Hi I would really like your help.

    The function is want is on one sheet you select a day and on the next it grey out that day. Iv changed it for the sheets to show what i want it to look like.

    The test is what i want it to look like and the sheet i need doing is well, what i would like to add the function too.

    So on team leader core hours you pick date in C16 and D16

    I would like all the days so C16 has Monday and D16 has Wednesday on the Jan sheet to be greyed out.

    So if they pick a new set of days it just greys out that day

    hope this makes sense.
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,025

    Re: Grey out areas when i select dates from a drop down

    Use this as the CF formula:

    =OR(LEFT(_Team_leader_core_hours!$C$16,3)=C$2,LEFT(_Team_leader_core_hours!$D$16,3)=C$2)
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    11-18-2009
    Location
    England
    MS-Off Ver
    Excel 2016
    Posts
    88

    Re: Grey out areas when i select dates from a drop down

    That's excellent thank you so much

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,025

    Re: Grey out areas when i select dates from a drop down

    You're welcome...

+ 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. Hiding Rows A & B- drop downs in other areas disappear
    By Dmaxin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-30-2013, 04:52 PM
  2. need drop down calendare in the areas this form ask for dates
    By superchew in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-30-2013, 04:52 PM
  3. Replies: 7
    Last Post: 12-02-2011, 09:56 PM
  4. Macro to select Print Areas in Excel to PowerPoint
    By jayman7 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-13-2009, 07:00 AM
  5. [SOLVED] Select Merge Areas
    By al in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-07-2005, 10:45 AM
  6. [SOLVED] Select certain visible/non-hidden areas
    By 0-0 Wai Wai ^-^ in forum Excel General
    Replies: 3
    Last Post: 09-08-2005, 04:05 PM
  7. [SOLVED] How do I select subtotal for a list when it is in grey?
    By Student05 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-22-2005, 09:06 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