View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jorgie jorgie is offline
external usenet poster
 
Posts: 1
Default conditional formating using dates

I have data that is entered from a report that is done periodically and dont
want users to use the spreadsheet after a specific date (this date is entered
into a header). So I want to be able to look at the current date and compare
it to the header date and if the current date exceeds the header date then
the spreadsheet becomes unusable.