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