The usual approach for this is to use Conditional Formatting. See:

http://www.contextures.com/xlCondFormat01.html

--
Gary''s Student - gsnu200800


"mcklein" wrote:

I'm creating a spreadsheet to track approaching deadlines for tasks to be
completed (on a construction project). I'm trying to figure out if there is a
function/formula that I can use to highlight cells as the dates approach. For
example, if today is 8/15/08, all cells that contain a 8/22/08 date or closer
would be highlighted.

Any help would be much appreciated.