![]() Note: With this function, the result is not case sensitive. And then you can fill background color for the different values just by clicking Home > Fill Color, see screenshot: In the Go To Special dialog box, select Row differences from the Select section, and click OK button, then the differences from another column data have been selected at once, see screenshot:ģ. Select the data that you want to compare two columns and highlight the differences, and then click Home > Find & Select > Go To Special, see screenshot:Ģ. If you are familiar with the Go To Special feature in Excel, it can help you to quickly select the column differences based on each row. ![]() Highlight column differences with Kutools for Excel Highlight column differences with Conditional formatting Highlight column differences with Go To Special function This article, I will introduce some useful and quick methods to deal with this task in Excel. ![]() If you have some values in two columns, and now, you want to compare them row by row to highlight the differences as following screenshot shown. How to highlight column differences in Excel?
0 Comments
Leave a Reply. |