compare 2 colomns and return fill red if is different

[bogd1n]

hello i need your help



i want to compare 2 colomns( A coulomn and B coulomn ) if data in coulomn B is different i want to change to red color


tks

compare.xlsx

[GC Excel]

Hello,

One way to do it is :
1. Select data
2. Press F5, Click Special, Select "Row Differences" and OK
3. Differences will be highlighted, select the red fill color

[GC Excel]

You can also do it with conditionnal formatting :

1. From B1, select all column B (example B1:B5)
2. Goto Conditionnal formatting, add new rule with formula
3. Use this formula : =B1<>A1
4. Select Red Fill color and press OK

[AlKey]

With Conditional formatting

=COUNTIF(A1:B5,B1)>1

Highlight B1:B5 and go to:

Conditional Formatting, New rule, Use Formula...

[bogd1n]

hello again
i ask you a simple version for my problem but the problem is little more difficult
i want to compare a list of coulomns A and B for example P.12242 with R1112242900 ; 12242 is commun number

i develop a formula with =IF(MID(A15,3,5)<>MID(B15,4,5),1,2)
but i dont now how i insert change color in it

sorry and thanks for help me

i presented a simple problem for i develop my abilities but it is little bit difficult
compare2.xlsx

[newdoverman]

Perhaps this is what you want:

Please Login or Register  to view this content.

Here is you sample with the Conditional Formatting applied.