How to change color if two cells are not equal in Excel?
There are two lists in a sheet which you need to compare and then change the row color if the two adjacent cells are not equal as below screenshot shown, have you any good methods to handle this job in Excel?
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
1. 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. Then click Format to open Format Cells dialog, and select one color under Fill tab. See screenshot:
3. Click OK > OK. Then the cells will be colored if the two cells are not equal to each other.
If you want to select and color cells if not equal to each other, you can apply Kutools for Excel’s Compare Cells utility.
|Kutools for Excel, with more than 300 handy functions, makes your jobs more easier.|
After installing Kutools for Excel, please do as below:（Free Download Kutools for Excel Now!)
1. Select the two lists separately by holding Ctrl key. See screenshot:
2. Click Kutools > Compare Cells, in the Compare Cells dialog, check Different cells option, and check Fill backcolor or Fill font color options as you need, select one color you want. See screenshot:
3. Click Ok, a dialog pops out to remind you how many different cells have been selected and highlighted. Click OK to close the reminder dialog. See screenshot: