+ Reply to Thread
Results 1 to 2 of 2

Trying to highlight a row based on date

  1. #1
    Registered User
    Join Date
    04-26-2019
    Location
    Ontario, Canada
    MS-Off Ver
    MS Office 2016
    Posts
    1

    Post Trying to highlight a row based on date

    Hi, I'm not sure if I'm in the right thread but I believe I am. I'm looking to have rows highlight if the date in column C is within 5 days of the date in column E. I'm also hoping to have a calculation at the bottom to say how many rows have been highlighted due to this criteria. Then I was hoping to have a separate calculation that shows how many are highlighted based on this criteria that also have a certain name in column B. Is there a formula/macro for this? I would like to post a copy of my excel sheet but unfortunately it has confidential data. I would appreciate any help you might be able to offer.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,434

    Re: Trying to highlight a row based on date

    You could just use Conditional Formatting to highlight the rows. And, rather than mess about with VBA, you could use Autofilter (on colour) to view only the rows highlighted. Lastly, you could use SUBTOTAL to count and/or sum the visible rows.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. How to highlight rows based on a date
    By enac in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-26-2016, 08:26 AM
  2. [SOLVED] Highlight cells based on date
    By lavudyar in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 9
    Last Post: 05-01-2015, 12:38 AM
  3. Highlight Rows Based on Date Range Using Static Date and Current Date
    By SaraStravers in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-23-2015, 07:38 PM
  4. Highlight row based on next date in table
    By kgpetersen in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-19-2014, 01:53 AM
  5. [SOLVED] HIghlight cell based on Date
    By rz6657 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-08-2014, 10:08 AM
  6. [SOLVED] Highlight Data based on Date
    By rizmomin in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-09-2014, 10:41 PM
  7. Highlight an entire row based upon a date
    By tootlebug in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-26-2013, 11:49 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