VBA Macro to Color Row Text If Date in Cell is greater than system date

Hoping someone can help me here, as this is uncharted territory for me.

I am hoping to write a Macro that checks If the date in any cell in column U is 6 months greater than the system date, it will color the entire row's text red.

I found this tidbit out there, and was hoping someone can skillfully re-purpose it to do what I described above. From what I saw this may be the answer to what I was looking for but I am not yet skillful enough to do this myself.

The Assumptions for this sample was:

If the date in column H matches the system date, then those rows will become green.
If the date in column H is the next date (tomorrow), those rows will become yellow.
If the date in column H is 2 to 6 days out, those rows will become blue.
If the date in column H is 7 to 13 days out, those rows will become orange.
If the date in column H is 14 to 20 days out, those rows will become red.
If the date in column H is 21 to 27 days out, those rows will become tan.
If the date in column H is equal to or greater than 28 days out, those rows will remain white.

Please Login or Register  to view this content.

I hope what I'm looking for is somewhere in there, but if not I am open to suggestions on other methods to research.

Thanks!

Sorry, to clarify, the code above was from an example I pulled that I thought might be close to what I needed, I may be completely wrong...

The dates in my spreadsheet in column U are in the date format seen in the image below.

Hopefully this clarifies, but again I only need one scenario which is to check the date in each cell in column U, if it's more than 6 months greater than the system date, color the row red text.

Date Image.jpg

Judge thank you so much. This was a huge help. Again, VBA was needed versus conditional formatting because of the way the data gets exported from a central system.

I tweaked yours slightly so that it colors the text red versus changing the fill color. And had to change the variable as I already had one for "i" defined earlier on in the larger macro.

Please Login or Register  to view this content.