title: Color Duplicates within that week
body: <p>How do I automatically color duplicates in a column &quot;within that week&quot; while I am filling records in the sheet.</p>
  <p>For Eg: All new records within the week are colored Green and duplicates within that week is colored Orange.</p>
  <p><a href="https://i.stack.imgur.com/JctI0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JctI0.png" alt="Week wise Duplicates" /></a></p>
  <p>I have been trying Format &gt; Conditional Formatting however I am not sure what to enter in the Custom Formula to limit the search and highlight week wise.</p>
  <p>Any help is appreciated. Here's a sample sheet and expected results</p>
  <p><a href="https://docs.google.com/spreadsheets/d/1W5TzBTL_Y2hhXJvmaiIa7_UmMG8bjC1GHyc6B91mxZ8/edit?usp=sharing" rel="nofollow noreferrer">Week wise Duplicates</a></p>