View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
collyer3 collyer3 is offline
external usenet poster
 
Posts: 7
Default Flagging an outdated cell

Along the same lines as another thread I read earlier, I am trying to set up
cells that will turn red or have a validation message pop up if the date in
the cell is over 60 days old from today's date. I want it set up so when I
open the spreadsheet, if the date in, let's say, cell K8 is 7/11/2008, that
the cell should be red, or I have a message pop up when select the cell
saying that this is outdated. Is there a way to do that?