Hi,
I am using conditional formatting in some columns to highlight duplicate values.
I set the rule to apply to F:F but I have to delete cells/insert cells all the time that messes the conditional formatting up to something like the below.
Applies to change from F:F ot =$F$84:$F$85 and =$F$1:$F$83,$F$86:$F$1048576.
How do I stop it from changing?
Thanks
Bookmarks