I have a spreadsheet with dates in a row. I am able to create a macro to highlight the colum of todays date but would also like to create a macro to select a date i enter in a specific cell.
I have used the folrmula below which is a slight variation on the one that finds todays date and works well.
My dates are in row 2
FindDate is the name have given cell A2 where I enter the date I am searching for. This is simply Date in the macro that finds todays date.
Thanks in advance.
Formula:Please Login or Register to view this content.
Bookmarks