date question

[david]

I have a sheet that has meeting dates and other
information. The sheet has upcoming meeting dates and also
old meeting dates (dates that are already past). How can I
check to make sure that the meeting I select is the most
recent one. I am trying to get it to check whether or not
the date is past the current date, but I don't know how to
do it.

Thanks for your help,
David

 

[steve]

David,

I tried Conditional Formating and set:
Cell Value greater than =Now()
and set the format to color the font.

You could also try greater than or equal to

Or you could get really sneaky and use the Formula Is and refer to a cell on
the sheet. Than either enter a date in the cell or a formula.

You could also do the reverse and set the Font style to strikethru for past
dates.

Once you get the hang of Conditional Formating, you can record a macro and
do it by sub...

steve