how do I create conditional format

P

pwolffie

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
 
B

Biff

Hi!

Assume your data is in the range A1:B20.

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

Biff
 
P

pwolffie

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!
 
Top