find today() within a range of dates and highlight cells

  • Please help


    I have a spreadsheet that has set time periods by groups of date ranges.
    As you can see in cell E1 i have used a formula, but that will only work on the adjusted table below the one I want to use.
    What I want is some VBA so when the workbook is opened that the current period (within A4:A15) to be populated as E1, the corresponding CY added to F1 and the corresponding date range (start/Finish cells) highlighted (interiorcolour).
    I have attached the workbook.

  • Re: find today() within a range of dates and highlight cells


    Possibly...

    If I've been helpful, let me know. If I haven't, let me know that too. 

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!