Conditional Formating

[rsv]

I am trying to analyze a long list of contacts and identify which companies have multiple record owners. I'd like to find a command which will highlight all of records which have multiple record owners.

Below I have manually shaded the cells that have multiple record owners (1151 and 2) (column B). Is there a formula or command to do this to a long list?

(Sorry for explaining this poorly...it's been a long day!)

Column A Column B
BOX CO 1151
BOX CO 2
ABC 45
ABC 45

 

[Jerry Sullivan]

Hello and Welcome,

You could use a Conditional Formatting formula that evaluates to TRUE
when the Count of the Company Name is greater than the Count of the Company Name & Owner.

Sheet1

<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: 118px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>A</TD><TD>B</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD>Company</TD><TD>Owner</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="COLOR: #ff0000; FONT-WEIGHT: bold">BOX CO</TD><TD style="TEXT-ALIGN: right; COLOR: #ff0000; FONT-WEIGHT: bold">1151</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="COLOR: #ff0000; FONT-WEIGHT: bold">BOX CO</TD><TD style="TEXT-ALIGN: right; COLOR: #ff0000; FONT-WEIGHT: bold">2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD>ABC</TD><TD style="TEXT-ALIGN: right">45</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD>ABC</TD><TD style="TEXT-ALIGN: right">45</TD></TR></TBODY></TABLE>
<TABLE style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #ff0000; BORDER-RIGHT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #ff0000; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; BORDER-RIGHT-COLOR: #ff0000; FONT-SIZE: 10pt; BORDER-LEFT-STYLE: groove; BORDER-LEFT-COLOR: #ff0000"><TBODY><TR><TD>Conditional formatting </TD></TR><TR><TD><TABLE style="PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial; FONT-SIZE: 10pt" border=1 cellSpacing=0 cellPadding=0><TBODY><TR><TD>Cell</TD><TD>Nr.: / Condition</TD><TD>Format</TD></TR><TR><TD>A2</TD><TD>1. / Formula is =COUNTIF($A$2:$A$1000,$A2)>SUM(IF($A$2:$A$1000& $B$2:$B$1000=$A2 & $B2,1,0))</TD><TD style="BACKGROUND-COLOR: #000000; FONT-STYLE: italic; COLOR: #ff0000; FONT-WEIGHT: bold">Abc</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
Excel tables to the web - Excel Jeanie Html 4