VBA Mark Row if Date in it older than..
Hi, I found nothing in the internet, so I ask here.
How can I mark all rows yellow in an excel file with dates older than for ex. 4 years in Column D?
The code should only do that for rows, where "this" is in Column C. For example this:
06-01-2017 11-17-39.png
Hope someone can understand.
Have you checked out the Conditional Formatting functionality, using the 'Formula...' option and specifying something like
Formula:
Please Login or Register to view this content.
However I'm puzzled by the rows you have marked since the dates aren't older than 4 years
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Do you want to highlight the entire row if the Date in D column is 4 year greater than Today's date?
why not use conditional formatting .
If it is not the case please elaborate your question further.
Best Regards
Irman Bhatti
Teach me Excel VBA
@excelisfun009
Yes, but I want to use a VBA Code for this and I only want to consider the rows with "this" in row C. So basically it would be like this:
that 2015
this 2013
this 2016
that 2005
this 2005
VBA version of Richards solution is here:
Best Regards
Please Login or Register to view this content.
Imran Bhatti
Last edited by ImranBhatti; 01-06-2017 at 02:55 PM. Reason: Amendments in code
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks