Thread: duplicate dates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default duplicate dates
Conditional Formatting

=COUNTIF($A:$F,A1)1

adjust your range to suit



"db" wrote:

In a worksheet with multiple columns of dates, how can I identify any
duplicate dates , if any, among columns. many thanks
--
db
Reply With QuoteReply With Quote