Conditional Formula for time window to include a buffer zone

Originally Posted by sonny.thind

But is there a macro to send an email with the entire row when the value in 'J2' changes to Say "Early" or "Late"?

Please post that question separately in the Excel Programming forum.