Ok, it's returning the error because you are using Conditional Formatting (CF), instead of traditional colors. You can tweak the macro I wrote to do all that highlighting for you, if you'd like.