View Single Post
  #2   Report Post  
Dave O
 
Posts: n/a
Default

Rather than pop up a message, how about if you set the conditional
formatting for the cells in column B to highlight if a duplicate
extension is entered?

Set conditional formatting to "formula is" and use this formula
(altered, of course, to fit your data):
=COUNTIF($B$2:$B$17,B2)1

Then set it to highlight in red or yellow to indicate a duplicate.