I'd like to use a conditional format to highlight an entire row in my work sheet based on the date in column A...and as the date changes the specific row associated with that date be highlighted....