LinkBack URL
About LinkBacks
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
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
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
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
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
With Conditional formatting
=COUNTIF(A1:B5,B1)>1
Highlight B1:B5 and go to:
Conditional Formatting, New rule, Use Formula...
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
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
Perhaps this is what you want:
Formula:
Please Login or Register to view this content.
Here is you sample with the Conditional Formatting applied.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks