+ Reply to Thread
Results 1 to 6 of 6

Help with Macro to highlight cells between dates

  1. #1
    Registered User
    Join Date
    06-05-2008
    Posts
    84

    Help with Macro to highlight cells between dates

    All,
    I have a sheet that I need to highlight each row between dates.

    So I have row 6 Column C6=Start Date, D6=Weeks (this is how many weeks I need the highlight to go) Or E6=End date and can highlight between the 2.
    Then loop each row thats filled in as this will be added to on a regular basis and updated/changed.


    In the sheet example I have done the first couple.


    Hope I am explaining this enough.
    Thanks
    Attached Files Attached Files

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Help with Macro to highlight cells between dates

    You may try this.......

    Please Login or Register  to view this content.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Help with Macro to highlight cells between dates

    The end date will be always present or do we need to calculate it?
    - Battle without fear gives no glory - Just try

  4. #4
    Registered User
    Join Date
    06-05-2008
    Posts
    84

    Re: Help with Macro to highlight cells between dates

    The End Date will be added by the user.

  5. #5
    Registered User
    Join Date
    06-05-2008
    Posts
    84

    Re: Help with Macro to highlight cells between dates

    Thank you SKTNEER that seems to be working just as I need it to.

    Thanks again.

  6. #6
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Help with Macro to highlight cells between dates

    You're welcome.

    If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.

+ 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] Highlight Cells Based on Dates
    By pugsly8422 in forum Excel General
    Replies: 3
    Last Post: 01-27-2015, 01:09 PM
  2. Need a 'conditional formatting' formula to highlight cells between dates/text
    By BigSean762 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-29-2014, 02:33 PM
  3. [SOLVED] Trying to get Excel to highlight cells based on assigned dates.
    By tatumrae in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-10-2013, 08:25 PM
  4. Macro to color highlight dates in certain range. Please help.
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-29-2011, 09:55 AM
  5. [SOLVED] automatically highlight cells with expired dates?!
    By cwest123456 in forum Excel General
    Replies: 2
    Last Post: 08-01-2005, 02:05 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