Use conditional formatting on the first column with a formula of

=COUNTIF(A:A,A1)>1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"dTHMTLGOD" <DTHMTL@YAHOO2.COM> wrote in message
news:eN0M1KGaGHA.4752@TK2MSFTNGP02.phx.gbl...
> I would like to determine if I have more than one occurrence of two
criteria
>
> User CN
> AA42171 Computer1
> AA42171 Laptop1
> AB44593 Computer1
> AF45945 Computer1
> DF86535 Computer1
> DF86535 Computer2
>
> I would like to pull if a user has both a Computer1 and Laptop1
>
>
>