+ Reply to Thread
Results 1 to 4 of 4

Highlight dates between (on a row ) a start and end date (inputs for vacation)

  1. 02-11-2020, 06:26 AM #1
    jayarajmarydasan
    jayarajmarydasan is offline
    Registered User
    Join Date
    06-29-2015
    Location
    Dubai
    MS-Off Ver
    2013
    Posts
    24

    Lightbulb Highlight dates between (on a row ) a start and end date (inputs for vacation)

    Good day all

    I like to maintain a vacation list of HR purpose. Empolyee names on column A, Start vacation date on Column B , end vacation date on Column C,

    I have filled dates from 01/01/2020 from cell D2 onwards towards right. I like to format each cells , that are between start date and end dates on each rows with a color .
    This will continue for other employees whose dates are filled in below rows . Even a conditional formatting formula is ok for me.

    Attached a same excel sheet to serve for testing

    regards

    Jayaraj
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-11-2020, 06:32 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,759

    Re: Highlight dates between (on a row ) a start and end date (inputs for vacation)

    Your conditional formatting rule for D2:

    =AND(D2>=$B2,$D$2<=$C2)

    Applied to: =$D$2:$GC$5
    Attached Files Attached Files
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 02-11-2020, 07:38 AM #3
    jayarajmarydasan
    jayarajmarydasan is offline
    Registered User
    Join Date
    06-29-2015
    Location
    Dubai
    MS-Off Ver
    2013
    Posts
    24

    Re: Highlight dates between (on a row ) a start and end date (inputs for vacation)

    Good day

    Thanks for assisting AliGW. Its really working good as i expect.
    Reply With QuoteRegister To Reply
  4. 02-11-2020, 08:19 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,759

    Re: Highlight dates between (on a row ) a start and end date (inputs for vacation)

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Generate Dates by Month along columns based on Start Date and End Date
    By Stndsh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-23-2015, 05:32 AM
  2. Setting a start date and end date for Index-Match within a list of dates
    By wiqbal in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-04-2015, 10:00 PM
  3. [SOLVED] Help in writing formula in excel to produce dates based on start date and end date
    By shoot for moon in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-10-2014, 01:00 PM
  4. [SOLVED] Vlookup on Dates and generating date range based upon inputs
    By Chardo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-14-2014, 05:13 PM
  5. Return cell value on calendar for all dates between start date & end date
    By mmctague in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-23-2012, 02:11 PM
  6. Formula Needed to calculate Vacation Time Based on start date
    By mdayco in forum Excel General
    Replies: 1
    Last Post: 03-31-2011, 05:03 PM
  7. I need formula to figure out vacation accrual with a start date of jan 1
    By abmartin in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-21-2010, 02:50 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1