Checking for duplicates across all cells
<p>How do I code this in the most simplest way?</p>

<p>If let's say <code>Range("A1").value = "Thursday"</code></p>

<p>Check for duplicates on all the cells which has value in them (B1, C1, D1,...)</p>

<p>If a duplicate is found, select 3 cells below each of those cells <code>Range("B2:B4")</code> and so on...</p>