Tracking dates

[the old guy]

I need to set up a spread sheet that will thack dates and will change colors if a date is not met or to another color if the date is met. I also need to shear this work book and be able to update the master form returned workbooks. can you give me some idea on how to get started.

 

[jeffreybrown]

Hello and Welcome to the Board,

For the first question check out the site http://www.contextures.com/xlCondFormat01.html

and question two you probably want to look at creating links.