Duplicate Values in Columns, Ignoring Same Row

[brysten12]

Well, I've searched the web and have apparently developed a table style that is rarely used and am having a difficult time finding help with my issue.

A brief background: I'm tracking what has/has not been done to certain vehicles at our dealership (taken pictures, write a description, etc). I currently have a table setup where after the pictures are taken for a vehicle, we'll add the stock number to the column "Pics Taken". After writing the description, we'll add the stock number to the same row (to keep everything organized) and the column "Description", and so on for the different tasks.

To avoid any duplication, I was hoping to write a Conditional Formatting code that would highlight a row if a stock number already appeared in another row. For example, if I marked in cell B15 ('B' being the column for "Pics Taken") the stock number '12345' and then in C23 ('C' for "Description") the same stock number, I would like to be warned of this mistake so I can properly move the second stock number entry to C15 (proper column, same row for organization). The difficulty I'm having is accomplishing this without having row 15 become highlighted because of the duplication in columns B and C.

In otherwords, the statement I would like to make is: does value B15 appear elsewhere in columns A:E but NOT row 15?

Any and all help would be greatly appreciated!!!

 

[VoG]

Perhaps the CF formula

=COUNTIF(A:E,B15)>1

 

[brysten12]

I didn't specifically say it, but I actually have 5 columns in total that could have the same value, so the >1 will still allow the same row to become highlighted.

 

[VoG]

Try posting a shot of part of your sheet (using dummy data if necessary) using Excel Jeanie http://www.excel-jeanie-html.de/html/hlp_schnell_en.php

 

[brysten12]

With this image, a restatement of my issue would be: I don't want row 15 to be highlighted UNLESS the value "45781" were to appear in any other row (1-14 or 16-...), columns A:E.

*UPDATE - I'm sorry, I didn't see the excel jeanie link until after I posted this!

 

[VoG]

Unfortunately you have posted a picture which we can't use to copy your data into excel.

Select A1:E50 (or to the end row) and try this CF formula

=COUNTIF($A$1:$E$50,A1)>COUNTIF($A1:$E1,A1)

 

[brysten12]

VinSol Stock #s


<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 88px"><COL style="WIDTH: 88px"><COL style="WIDTH: 88px"><COL style="WIDTH: 88px"><COL style="WIDTH: 88px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="TEXT-ALIGN: left; FONT-SIZE: 12pt; FONT-WEIGHT: bold; TEXT-DECORATION: underline">Blank</TD><TD style="TEXT-ALIGN: left; FONT-SIZE: 12pt; FONT-WEIGHT: bold; TEXT-DECORATION: underline">Ted Pic</TD><TD style="TEXT-ALIGN: left; FONT-SIZE: 12pt; FONT-WEIGHT: bold; TEXT-DECORATION: underline">BJ Fixed</TD><TD style="TEXT-ALIGN: left; FONT-SIZE: 12pt; FONT-WEIGHT: bold; TEXT-DECORATION: underline">Comment</TD><TD style="TEXT-ALIGN: left; FONT-SIZE: 12pt; FONT-WEIGHT: bold; TEXT-DECORATION: underline">Whole</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: center">45461</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">43091</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">45172</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">145221</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">44371</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">45761</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">45392</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">43671</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">85841</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">45401</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">45781</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">45781</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">45781</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="BACKGROUND-COLOR: #75923c"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">44392</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">44392</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">44392</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">44151</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">44151</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">44151</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">245701</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">245701</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">245701</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">45681</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">45681</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">45681</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">45691</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">45691</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">45691</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">245212</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">245212</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">245212</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">45382</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">45382</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">45382</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">143161</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">143161</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">143161</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">44602</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">44602</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">44602</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">44591</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">44591</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">44591</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">144871</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">144871</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">144871</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">27</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">45521</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">45521</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">45521</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">28</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">45531</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">45531</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">45531</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">29</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">45501</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">45501</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">45501</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">30</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">45511</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">45511</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">45511</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">31</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">45371</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">45371</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">45371</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">32</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">44712</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">44712</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">44712</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">33</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">45071</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">45071</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">34</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">45451</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">45451</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">45451</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">35</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">43351</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">43351</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">43351</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">36</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">45291</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">45291</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">37</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">45331</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">45331</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">38</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">45351</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">45351</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">39</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">45102</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">45102</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">45102</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">40</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">45131</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">45131</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">41</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">45091</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">45091</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">42</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">141331</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">141331</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">43</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">41011</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">41011</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">41011</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">44</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">44901</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">44901</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">45</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">44731</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">44731</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">46</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">44631</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">44631</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">47</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">44701</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">44701</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">48</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">44442</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">44442</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">49</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">44082</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">44082</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">50</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">44621</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">44621</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">51</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">44572</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">44572</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">52</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">144551</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">144551</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">53</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">44471</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">44471</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">54</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">144041</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">144041</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">144041</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">55</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">43991</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">43991</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">56</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">144501</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">57</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">44771</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">58</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">145111</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">59</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">44742</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">60</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">43671</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">61</TD><TD style="BACKGROUND-COLOR: #c00000"> </TD><TD style="BACKGROUND-COLOR: #c00000"> </TD><TD style="BACKGROUND-COLOR: #c00000"> </TD><TD style="BACKGROUND-COLOR: #c00000"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c00000; COLOR: #969696">44683</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">62</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">41604</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">63</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">45042</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">64</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">45911</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">45911</TD><TD style="BACKGROUND-COLOR: #75923c"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">65</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">45571</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">66</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">45881</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">67</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">45901</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">68</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">142671</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">69</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">145811</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">70</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">45651</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">71</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">45871</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">72</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">145771</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">73</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5">44201</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">74</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">44762</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">75</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">76</TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD><TD style="BACKGROUND-COLOR: #d8d8d8"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">77</TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD><TD style="BACKGROUND-COLOR: #a5a5a5"> </TD></TR></TBODY></TABLE>


Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4



This is what I got after using your previous recommendation. Note that "43671" is an actual duplicate on different rows (12 & 60)

 

[VoG]

Maybe

=AND(A$2<>"",COUNTIF($A$2:$E$100,A2)>COUNTIF($A1:$E1,A2))

Excel Workbook
	A	B	C	D	E
1	Blank	Ted Pic	BJ Fixed	Comment	Whole
2	45461
3	43091
4	45172
5	145221
6	44371
7	45761
8	45392
9	43671
10	85841
11	45401
12		45781	45781	45781
13		44392	44392	44392
14		44151	44151	44151
15		245701	245701	245701
16		45681	45681	45681
17		45691	45691	45691
18		245212	245212	245212
19		45382	45382	45382
20		143161	143161	143161
21		44602	44602	44602
22		44591	44591	44591
23		144871	144871	144871
24		45521	45521	45521
25		45531	45531	45531
26		45501	45501	45501
27		45511	45511	45511
28		45371	45371	45371
29		44712	44712	44712
30		45071	45071
31		45451	45451	45451
32		43351	43351	43351
33		45291	45291
34		45331	45331
35		45351	45351
36		45102	45102	45102
37		45131	45131
38		45091	45091
39		141331	141331
40		41011	41011	41011
41		44901	44901
42		44731	44731
43		44631	44631
44		44701	44701
45		44442	44442
46		44082	44082
47		44621	44621
48		44572	44572
49		144551	144551
50		44471	44471
51		144041	144041	144041
52		43991	43991
53					144501
54					44771
55					145111
56					44742
57					43671
58					44683
59					41604
60					45042
61		45911		45911
62		45571
63		45881
64		45901
65					142671
66	145811
67	45651
68	45871
69	145771
70					44201
71					44762
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2	1. / Formula is =AND(A$2<>"",COUNTIF($A$2:$E$100,A2)>COUNTIF($A2:$E2,A2))	Abc

 

[brysten12]

I tried that code and it didn't work either, although I like the direction you're going with it. The one issue that stood out to me is that only one of the two "43671"s were highlighted.