Weirdness in Excel 2007, with the "Conditional Formatting -> Highlight Duplicate Values" function.
Is the angle bracket a special character...it seems to be throwing the results (or have I got a buggy copy)?
Highlight a large range of cells and select "Home -> Conditional Formatting --> Highlight Cells Rules -> Duplicate Values" (then pick a colour or leave as default pink / red)
Now any duplicate values you enter into the range will automatically highlight (as expected).
However if I enter a value preceded by an angle bracket, it highlights without there being a matching value anywhere else.
What's going on there?
(I have a load of values, all surrounded by angle brackets...they're all being flagged as duplicates when very few of them actually are...)