Highlighting Duplicate Entries

[Rafe R Dimmitt]

I have a spreadsheet with 122 rows and 5 columns where
columns C, D & E are Windows Installer based GUIDs.

Using examples of Conditional Formatting that I've found
on various web sites and text books, I have tried (with
very limited success) to apply Conditional Formatting
across columns C, D & E in such a way that if there is a
GUID in C5 that is identical to one in E24, both are
highlighted. Before making an expensive product support
call I would like to see if someone else has done this
before.

Thanks,

Rafe R Dimmitt

 

[Bob Phillips]

Rafe,

Using Conditional Formatting,

select C1:C122
set Condition1 to FormulaIs
add this formula
=OR(COUNTIF($C$1:$C$122,C1)>1,COUNTIF($D$1:$D$122,C1)>0,COUNTIF($E$1:$E$122,
C1)>0)
Select Format button, Pattern tab, select chsoen colour and exit

In D1122
exactly the same, but this formula
=OR(COUNTIF($C$1:$C$122,D1)>0,COUNTIF($D$1:$D$122,D1)>1,COUNTIF($E$1:$E$122,
D1)>0)

In E1:E122
exactly the same, but this formula
=OR(COUNTIF($C$1:$C$122,E1)>0,COUNTIF($D$1:$D$122,E1)>0,COUNTIF($E$1:$E$122,
E1)>1)