Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
date question
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
date question
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 "david" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date question | Excel Worksheet Functions | |||
Date question | Excel Worksheet Functions | |||
Date Question | Excel Worksheet Functions | |||
Date Question | Excel Discussion (Misc queries) | |||
Date Question | Excel Worksheet Functions |