Looking to write a macro that will look at the cells above the active cell within a column which has dates in it and IF the date is less than the date in current cell it would look at the numbers in a different column and see if there is a duplicate number. If there is one it would high light the number cell. Any ideas? Or is there a better way to do this?