Forum Discussion
Conditional formatting in a column that highlights the cell if it matches data in another worksheet
Hello! I am wanting to apply a conditional format formula that will highlight a cell in a colmun if it contains the same data from a column in another sheet. The formula I have found is not working ...
Catherine_Robertshawe try using this in the conditional formatting menu.
=Countif('sheet 1'!$C$2:$C$5,$B2)=0
That seemed to work for me. You will need to put a second rule in so that it doesn't highlight the blanks though.