+ Reply to Thread
Results 1 to 5 of 5

Highlight cells between two dates

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Highlight cells between two dates

    Hello everyone
    I have dates in Column E & F (in column E start dates & in Column F end dates)
    I need to highlight the cells in other columns according the dates
    Here's an attachment ..the expected results done for first row of data
    I need VBA solution not conditional formatting as I have large amounts of data
    Thanks advanced
    Attached Files Attached Files
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,524

    Re: Highlight cells between two dates

    Please Login or Register  to view this content.

  3. #3
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    861

    Re: Highlight cells between two dates

    Take a look at the attached file. the code assumes that column D is the number of days between the dates (right?).
    Attached Files Attached Files
    .. and don't forget to have fun!
    Bogdan.

    mark SOLVED and Add Reputation if my answer pleases you

  4. #4
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Highlight cells between two dates

    Thank you very much Mr. jindon for this gift and for all of your magic gifts
    Thanks a lot for everything

  5. #5
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Highlight cells between two dates

    Hi bulina2k
    Thanks for offering help and for this nice code
    I just change this line to get it work for me
    Please Login or Register  to view this content.

+ 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] Help with Macro to highlight cells between dates
    By Slomaro2000 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-27-2015, 03:29 PM
  2. [SOLVED] Highlight Cells Based on Dates
    By pugsly8422 in forum Excel General
    Replies: 3
    Last Post: 01-27-2015, 01:09 PM
  3. Replies: 0
    Last Post: 08-12-2013, 03:06 PM
  4. [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
  5. 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