Hi!

Assume your data is in the range A1:B20.

Select the range A1:B20
Goto FormatConditional Formatting.
Formula is: =COUNTIF($A$1:$B$20,A1)1
Click the Format button then select the styles you want.
OK out

Biff

-----Original Message-----
I am trying to set up conditional formatting for my
spreadsheet to check for
duplicate addresses. The addresses are entered in two
columns (house number
and street name). If there is a match on these two
columns I would like the
duplicate data to appear red. If somebody knows the
formula I should use, I
would really appreciate it!

Thanks-
Paula
.