Excel 2007 : Conditional formatting help

Hey all,

I'm trying to set up a spreadsheet that will use conditional formatting to check for duplicates... here's what I'm trying to do and my problem:

I'm taking exact addresses (1000 e nowhere st) and turning them into more casual addresses (the intersection of nowhere st and nowhere blvd)

I have to do this every week or so and I was going to keep an archive of all the ones I had previously done and when I worked on new ones, it would check to see if there were any duplicates (IE: see if the same location has already been done before so I don't have to do it again).

I'm using excel 07 and used the conditional formatting to highlight duplicates in the same column, but once I delete the text out of the column and put in something else, the formatting goes away. Despite the fact that the text I enter is a duplicate to an existing entry below it, I have to redo the formatting again for it to highlight them.

Any ideas? Thanks!

I did what you did in Excel 2007, and I'm not having any problems.

Did you by any chance create it in 2007 and save it in compatibility mode (97-2003 format)?

Also, are you clicking the column heading (ie. A, B, C, etc.), prior to setting-up the conditional formating, so it affects all cells in that column?