comparing two list of datas in excel and doing conditional formatting
Hey Guys,
I was just trying to compare two lists of invoices and highlight the unique data in a list from another list. I used the formula in conditional formatting but it is not working as i am trying to do. i used =COUNTIF($C$12:$C$18,E12)=0 formula in conditional formatting to highlight unique datas in one of the list from another list. Can you guys help me out with this. I tried to do using the content in the url below.
http://chandoo.org/wp/2010/06/17/com...ists-in-excel/
Thanks,
Safal
Safal, welcome to ExcelFox
Can you attach a sample workbook, and explain what you are trying to achieve with the above formula. That may give a better perspective to the developer who tries to solve your query.
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
I just want to give conditional formatting to the unique customers in either lists. i just want to know how the countif is used with the conditional formatting. i want to get the detailed explanation.
You could select the second range, and go to conditional format, use the Formula section, and put =AND(NOT(ISBLANK($D5)),COUNTIF($B$5:$B$11,$D5)=0). ....
The ISBLANK is just used to ensure that we do not format any blank values unnecessarily. Check attachment.
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Hi,
Try this
Posting Permissions
Reply With Quote
Bookmarks