I have a excel in which the user enters date in column D. I need to highlight the cells in column D if the user does not enter the date in the format "mmm-dd-yyyy hh:mm:ss" . I tried conditional formatting but the problem is the users might copy and paste bulk dates in Column D. So I need a macro that validates and highlights the date after the user has entered the date. The macro should highlight the dates that are in other format than ""mmm-dd-yyyy hh:mm:ss".
Bookmarks