Conditional Formatting changes when I sort the data.

[excelnow]

Hi,

I have a column of data and I have a conditional formatting rule for highighting duplicate values. So, at first I apply the rule to the whole column ($C:$C), but then when I sort the column etc., the rule changes to something like this:

=$C$1:$C$2173;$C$2175:$C$2183;$C$2185:$C$1048576

It seems, it skips one or two cells when I sort the column. Is there any way to prevent this?

 

[jasmith4]

I can't see anything. I get a Zip file with a bunch of XMLs and VbaProject.bin.