Dups and Conditional Formating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Thanks to cpearson.com I can highlight dups. But I need to combine this with
another condition.
I want to identify dups in Col B only if the dup record contains (column K)
"no record". (Both of the dup records will have this string if either does.)
I've tried Formula =countif ($B$12:$B$928, B12)>1 and
Formula =$K12$K$928 =no record
as the conditions. Also tried each as condition 1 and 2 and several
variations of the second formula. The results have been that the dups are
identified but the "No record" condition has no effect as Cond 1 or 2.
Any suggestions would be appreciated.
Thanks,
wal50
 
How about:
=if(and(countif($b$12:$b$928,b12)>1,k12="no record"),"dupe","not a dupe")
 
Thanks Dave. As always with this site, a quick and accurate reply.
I can use this to format the rows I want.
wal50
 
Back
Top