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.
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.
Hi,
Try this