I want to do a conditional rule, but can't seem to get it to work correctly. I want to compare Column F with Column C. If Column F does not match Column C, and it is not empty, I want it to highlight red. Issue is that when the below formula, some of the cells that match the value, it is still highlighting it red.
=IF($c2=$f2, 1, 0)
However, it is highighliting some items that matches as well as blank cells. Any ideas?