+ Reply to Thread
Results 1 to 2 of 2

Adding a border from around a range based on todays date

  1. #1
    Registered User
    Join Date
    10-05-2014
    Location
    Nelson New Zealand
    MS-Off Ver
    2007
    Posts
    7

    Adding a border from around a range based on todays date

    Hello Everyone
    I currently have an excel sheet that has 96 columns grouped into sets of four.
    Each group of four make up a month. MonthsGroup.PNG

    I am trying to make it so the group of four that correspond to today's date would have a border of Red instead of just black.
    I figure that each group of four could be named as a range (july_2017, aug_2017, sep_2017, etc, etc) and then using a cell that automatically populates with today's date (=TODAY()), an "on open" event could check this date and then using an if statement, set the boarders of the corresponding group to red.

    However, VBA syntax has me not even knowing where to start. If there is an easier way to do this- like with conditional formatting for example, I would be more than happy to use that method instead.

    Any help woyld be much appreciated.

    Thanks

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Adding a border from around a range based on todays date

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

+ 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. Difficulty adding todays date in TEXT format
    By Gregbaron in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-08-2016, 12:04 PM
  2. SUMIF function not adding all non blank cells before todays date
    By unokam in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-09-2016, 03:25 PM
  3. Replies: 5
    Last Post: 01-05-2015, 03:57 PM
  4. How to define chart range based on todays date
    By dan162 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-16-2014, 11:37 AM
  5. Adding todays date to template automatically
    By DJL1984 in forum Excel General
    Replies: 2
    Last Post: 12-21-2009, 05:02 AM
  6. Problem setting range in macro based on todays date.
    By shakeyjake200 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-15-2009, 12:48 AM
  7. Using VB to find a range based on todays date and todays date +30
    By Steve_al in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2009, 09:31 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1