+ Reply to Thread
Results 1 to 7 of 7

Conditional formatting Highlight Cell between Start date and end date

  1. #1
    Registered User
    Join Date
    07-24-2018
    Location
    Dubai
    MS-Off Ver
    Office 2010
    Posts
    5

    Conditional formatting Highlight Cell between Start date and end date

    I have the start date and end date.
    I want to highlight the cell between the start to end date only if the total days is more than 10 days and I want it to highlight the cell every other 5 days from the start date until the end date.

    for example.
    if my start date is 01 January 2021 and the end date is 17 January then I want to highlight the cell which is on 05 Jan, 10 Jan, and 15 Jan.
    Attached Files Attached Files
    Last edited by dasameer69; 01-24-2021 at 10:15 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: Gantt Chart

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. I would do it for you if I fully understood your requirement ... You will need to do it yourself.)
    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.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: Conditional formatting Highlight Cell between Start date and end date

    Thank you for updating your title.

  4. #4
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,256

    Re: Conditional formatting Highlight Cell between Start date and end date

    Add this to your formula
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  5. #5
    Registered User
    Join Date
    07-24-2018
    Location
    Dubai
    MS-Off Ver
    Office 2010
    Posts
    5

    Re: Conditional formatting Highlight Cell between Start date and end date

    Thanks, Popipipo but I think my question was not clear.
    each row have a different start and Finish date so I only want to highlight from the start date + 5days until the end date
    if the start date is 02 Jan and the finish date is 15 Jan then I want to highlight 06 Jan, 11 Jan
    if the start date is 03 Jan and the finish date is 15 Jan then I want to highlight 07 Jan, 12 Jan

  6. #6
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,256

    Re: Conditional formatting Highlight Cell between Start date and end date

    Is this better?

    Please Login or Register  to view this content.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    07-24-2018
    Location
    Dubai
    MS-Off Ver
    Office 2010
    Posts
    5

    Re: Conditional formatting Highlight Cell between Start date and end date

    Thank you, Amazing.

+ 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. [SOLVED] Timeline Gantt chart - Chart bars are in reverse order
    By gan_xl in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-20-2019, 01:02 PM
  2. [SOLVED] Have the ability to view a daily Gantt chart as a monthly gantt chart
    By adam_d_john in forum Excel General
    Replies: 3
    Last Post: 03-13-2018, 09:11 PM
  3. Gantt Chart
    By PLNG in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-18-2017, 10:53 PM
  4. Replies: 0
    Last Post: 01-07-2015, 01:22 PM
  5. Gantt Chart
    By HCBalelo in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-15-2013, 09:02 PM
  6. Replies: 5
    Last Post: 10-04-2012, 07:01 AM
  7. Replies: 0
    Last Post: 07-13-2012, 06:40 PM

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