Could you give a specific example? If I understand, you'd want 1/1/2005 to
show as overdue on sheet 2, but it now resides only on sheet 1?
Seems to me you could copy the cell from sheet 1. Go to sheet 2 and
Edit--Paste special--Paste link. Then, make the font color white. Then,
using conditional formatting to show the font as black or red or something
when the value is less than today. Type: =today() into a cell. Then, go
to your "special" cell and hit Format--Conditional formatting. Cell Value
is Less than (tab) then click on the cell with Today in it.
************
Anne Troy
www.OfficeArticles.com


"Duncare" wrote in message
...
I am trying to set up an inspection database I need the values from other
pages to appear when they go overdue in a specific cell. Please help!!!