how do I create conditional format
 

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

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
.

Thanks for responding Biff!

That formula highlights all like street names (column D) regardless of house
number (column C). My range is C2:D888....if I want to locate those rows
where both the street number (C) and street name (D) to match each other what
can I add to the formula?


Thank you so much!

"Biff" wrote:

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
.