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 sample.xlsxothers should be highlighted in any color. Thanks in advance.
Just use cxonditional formatting with a formula of
=OR(A5<--"2014-01-01",A5>TODAY())
Bookmarks