• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 271
  • Last Modified:

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
0
gtmathewDallas
Asked:
gtmathewDallas
  • 2
1 Solution
 
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
 
NBVCCommented:
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now