<div>
Thank you so much! &nbsp;That almost works. &nbsp;It took a bit of testing but I find that it only returns &quot;TRUE&quot; if the older entry appears twice in the month in question. &nbsp;I changed the &quot;&gt;1&quot; to &quot;&gt;0&quot;. &nbsp;That seemed to fix it problem.. However, because I am new to Excel, did that change mess with the way the results will be reported?<br />
<br />
Again, thank you so very much.
</div>


Thank you so much!  That almost works.  It took a bit of testing but I find that it only returns "TRUE" if the older entry appears twice in the month in question.  I changed the ">1" to ">0".  That seemed to fix it problem.. However, because I am new to Excel, did that change mess with the way the results will be reported?

Again, thank you so very much.

<div>
ROB WAS QUICK AND GAVE A SUPER EASY TO UNDERSTAND ANSWER. &nbsp;HE ALSO PROVIDED AN IMPORTANT ALTERNATE CASE EXAMPLE.
</div>


ROB WAS QUICK AND GAVE A SUPER EASY TO UNDERSTAND ANSWER.  HE ALSO PROVIDED AN IMPORTANT ALTERNATE CASE EXAMPLE.

<div>
Changing to &quot;&gt;0&quot; would highlight all entries where there is 1 or more. The &quot;&gt;1&quot; would indicate where there is more than 1.<br />
<br />
Hopefully you now have it working how you want it.
</div>


Changing to ">0" would highlight all entries where there is 1 or more. The ">1" would indicate where there is more than 1.

Hopefully you now have it working how you want it.

<div>
<div class="content wysiwyg-content">
I have a column that contains data formatted like this &quot;nnnnn, text&quot;. &nbsp;There is one sheet per month. &nbsp;I wish to &quot;fill&quot; (color?) any cell that has identical data in any other sheet with a light shading.<br />
<br />
For example, in October I enter what I think is &quot;new data', say &quot;07300, Smith Residence&quot;. &nbsp;However, because I did not recall entering that same information in January I would like the cell shading to change from &quot;No Fill&quot; to a light fill so as to draw my attention to the duplication.
</div>
</div>


I have a column that contains data formatted like this "nnnnn, text".  There is one sheet per month.  I wish to "fill" (color?) any cell that has identical data in any other sheet with a light shading.

For example, in October I enter what I think is "new data', say "07300, Smith Residence".  However, because I did not recall entering that same information in January I would like the cell shading to change from "No Fill" to a light fill so as to draw my attention to the duplication.

Conditional formatting of a cell based on text anywhere in the workbook

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.