Thread: compare dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vic Vic is offline
external usenet poster
 
Posts: 117
Default compare dates

I have invoice numbers in column A (1234567ABC)
Date of invoice is in column B in this format 31-Mar-09
Date of product received is in column C in this format 04/15/09

I need to highlight in yellow each cell in column B (date of invoice) if it
is greater than a cell in column C (date of product received).