I need an excel expert

Need a sheet for lot control. Sheet 1 to show item, lot number, expiration date(formatted to show light yellow fill if within 10 days of expiring and light red fill day off expiration and on). Then an archive button to transfer that information to another sheet to archive forever in a running list. Attached pic for what i want sheet 1 to look like.