Compare two columns and high lite the different ones EXCEL

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
gtmathewDallasAsked:
Who is Participating?
 
NBVCConnect With a Mentor Commented:
If you select the entire column and apply the conditional format... it will automatically apply to all 400 rows and more.  (you can verify in the Applies to field of the CF Manager)
0
 
NBVCCommented:
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.
0
 
gtmathewDallasAuthor Commented:
But I have 400 rows :(
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.