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?
|