Date filter for specific dates

**excelhelpseeker** · 01-13-2015, 12:33 AM

Hi champs,

Please provide me a macro or function to capture date filter for the below requirement.

1. i need dates between jan 1 3014 and today's date. all others should be highlighted in any color. Thanks in advance.

**alansidman** · 01-13-2015, 12:53 AM

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 use the paperclip icon to open the upload window.

View Pic

**excelhelpseeker** · 01-13-2015, 01:03 AM

Hi,

Find attached sample.sample.xlsx

**alansidman** · 01-13-2015, 01:59 AM

Use conditional formatting

http://www.contextures.com/xlCondFormat03.html

**alansidman** · 01-13-2015, 01:59 AM

Use conditional formatting

http://www.contextures.com/xlCondFormat03.html

**excelhelpseeker** · 01-13-2015, 09:21 AM

Yes. i can by conditional formatting... whether can i get this done by help of a macro????

**alansidman** · 01-13-2015, 10:20 AM

Sure:

Try this:

Please Login or Register  to view this content.

**excelhelpseeker** · 01-14-2015, 04:01 AM

thanks. it doesnot capture the future dates.
if i need to color the tomorrow date and the future dates????... pls help

**alansidman** · 01-14-2015, 05:22 AM

This code will color only dates greater than today.

Option Explicit

Please Login or Register  to view this content.

**excelhelpseeker** · 01-14-2015, 05:37 AM

thanks for the help. it works fine................

Date filter for specific dates

LinkBack

Thread Tools

Rate This Thread

Display

Date filter for specific dates

Re: Date filter for specific dates

Re: Date filter for specific dates

Re: Date filter for specific dates

Re: Date filter for specific dates

Re: Date filter for specific dates

Re: Date filter for specific dates

Re: Date filter for specific dates

Re: Date filter for specific dates

Re: Date filter for specific dates

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA code to filter on Specific two dates ( pivot table)

[SOLVED] Filter dates according to current date

Custom date filter for next twelve months from a specific date

[SOLVED] Date Filter based on Cell Input - single date or range of dates

Problem with Date Filter between two dates

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions