Does not equal in Excel conditional formatting?
Does not equal in Excel conditional formatting?
How to change color if two cells are not equal in Excel? - ExtendOffice
Aug 1, 2019
Select two list you compare if equal to each other, and click Home ► Conditional Formatting ► New Rule. 2. In the New Formatting Rule dialog, choose Use a formula to determine which cells to format, and type this formula =$A1◄►$B1 into the Format values where this formula true.