+ Reply to Thread
Results 1 to 4 of 4

Highlight a date range if today's date falls within that range

  1. #1
    Registered User
    Join Date
    03-11-2014
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    6

    Highlight a date range if today's date falls within that range

    Novice Excel User Here ..... I have a employee travel spreadsheet with air travel dates in two columns. I want to be able to create a rule that will highlight all the cells in a row if the date range on that row fall includes today's date. Essentially, I am looking for a quick way to tell if someone is traveling in the event there is an emergency and I need to know if they are traveling that particular day. I have attached a sample spreadsheet.

    Thank you in advance
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Highlight a date range if today's date falls within that range

    Use conditional formatting, based on formula, so it will be =AND(Today()>=a1,Today<=b1)

    something like that.
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Registered User
    Join Date
    03-11-2014
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Highlight a date range if today's date falls within that range

    Based on the attached spreadsheet, rows 1, 2, 4, 5 and 6 should highlight red because today's date falls within that row's
    date range. I applied the formula you gave and couldn't get it to work. Book 555.xlsx

    Thanks for helping...

  4. #4
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Highlight a date range if today's date falls within that range

    You didnt put the brackets on your second today()

+ 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] Formula to assign specific numbers if a date falls within a certain date range
    By headley4ever in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-24-2014, 04:16 PM
  2. Replies: 4
    Last Post: 09-12-2013, 11:32 PM
  3. Search date range +/- 7 days and return date that falls within range
    By tlafferty in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-13-2013, 03:26 PM
  4. Replies: 15
    Last Post: 04-08-2013, 12:40 PM
  5. [SOLVED] highlight an entire row if a date in one column falls between a given range
    By cfmartin76@gmail.com in forum Excel General
    Replies: 1
    Last Post: 07-19-2006, 09:40 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