Macro about date compare
I have an excel sheet that contains dates in different cells.
I want a macro which: Each time I open the excel file, compares all shells
with dates with current date and if the date in a cell has exceeded current
date, then mark the whole row somehow, e.g. color the row with yellow color.
Please please help !!!!
|