Highlight Rows Based on Date

**basketball2524** · 08-25-2014, 07:43 PM

Does anybody know how to create a macro that will search Column G and based on the date the Macro is run determine which rows to highlight. If the date is within 5 days of when the Macro is run then the row will be highlighted Yellow. If the date is 7 days from the day the Macro is run then the row will be highlighted RED. test3.xlsx

**alansidman** · 08-25-2014, 08:44 PM

try this

Please Login or Register  to view this content.

**basketball2524** · 08-25-2014, 09:01 PM

That works but how do I get it to Highlight the entire row and not just change the font color?

**alansidman** · 08-25-2014, 09:29 PM

Try this instead:

Please Login or Register  to view this content.

Highlight Rows Based on Date

LinkBack

Thread Tools

Rate This Thread

Display

Highlight Rows Based on Date

Re: Highlight Rows Based on Date

Re: Highlight Rows Based on Date

Re: Highlight Rows Based on Date

Thread Information

Users Browsing this Thread

Similar Threads

Highlight row based on next date in table

[SOLVED] HIghlight cell based on Date

[SOLVED] Highlight Data based on Date

Highlight an entire row based upon a date

Highlight Rows Based on Corresponding Cell Value

Bookmarks

Bookmarks

Posting Permissions