<div>
Select the 2 columns.<br />
<br />
Go to Home|Conditional Formatting<br />
<br />
Select &quot;use a formula to determine which cells to format&quot;<br />
<br />
Enter formula like:<br />
<br />
=AND(ROW()&gt;1,$C1&lt;&gt;$D1)<br />
<br />
assuming column C is Id1 and column D is id3.<br />
<br />
click Format and choose from Fill tab.<br />
<br />
Click Ok and again to finish.
</div>


Select the 2 columns.

Go to Home|Conditional Formatting

Select "use a formula to determine which cells to format"

Enter formula like:

=AND(ROW()>1,$C1<>$D1)

assuming column C is Id1 and column D is id3.

click Format and choose from Fill tab.

Click Ok and again to finish.

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
I have an Excel sheet with different columns, assume the column names are- name(column1), id1(column2), id3(column3).<br />
I want to compare the column2 with column3 and if it is different - we need to high lite the row in a different color.The values in column1 and 2 are in number format. Please help..<br />
Thanks in advance
</div>
</div>


Hi Experts,
I have an Excel sheet with different columns, assume the column names are- name(column1), id1(column2), id3(column3).
I want to compare the column2 with column3 and if it is different - we need to high lite the row in a different color.The values in column1 and 2 are in number format. Please help..
Thanks in advance

Compare two columns and high lite the different ones EXCEL

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.