you could do this
(1) using Conditional Formatting. For exampl if you want to see duplicates
in D, then select the entire column, select Format/Conditional Formatting,
switch to Formula Is and add the formula
=AND(D1=D2,D1<"")
then select some back color or whatever

(2) use COUNTIF so in E1 put =COUNTIF(D:D,D1) copy the formula down.
use autofilter on E where the value <1 or 1

(3) in VBA:

col="D"
for rw = 2 to cells(1,col).End(xldown).Row
if cells(rw,col)=cells(rw-1,col) then
cells(rw,col).Iterior.Color=vbRed
end if
next

"HpyTrvlr69" wrote in message
...
Silly question for all you smart guys out here....where does one lookup
info
on the moving and selecting of cursor and cell locations programmatically
(Macro or VB). I know....Im really dumb!!