note that should have been sumif
=sumtif(A:A,A1,B:B)=0
"bj" wrote:

select column A
<format<conditional format
change value is to formula is
=countif(A:A,A1,B:B)=0
set format patterns to what you want
occasionally I have to go back into conditional formatting and remove quote
marks I do not want or change absolute and relative cell referencing as
needed. i have never been able to truely identify why, but think I am
probalbly just sloppy when I first do it.

"Diamonds_Mine" wrote:

Below is a sample list; I need to extract or highlight names in Column A that
have a zero value in column B, but if the name in Column A is listed multiple
times and the value in column B is greater than zero, it should not be
extracted or highlighted. So for the list below the result should be User 4
and User 5. Thank you.

Column A Column B
Name PST Folder Size
User 1 0
User 2 15
User 3 18
User 1 22
User 4 0
User 5 0