This seems like it should be easy enough, but I can't seem to find an easy answer.
I have information on column A and column B but I want the cells in column B to be highlighted if it doesn't match column A.
I could do it one at a time but with a few hundred lines, it would take a while. Also, I read posts about cloning the rule, but I can't find it and when I tried to special paste + formatting, it'll highlight everything
I have information on column A and column B but I want the cells in column B to be highlighted if it doesn't match column A.
I could do it one at a time but with a few hundred lines, it would take a while. Also, I read posts about cloning the rule, but I can't find it and when I tried to special paste + formatting, it'll highlight everything