Use Conditional formatting:

See:

http://www.contextures.com/xlCondFormat01.html
--
Gary''s Student - gsnu200851


"AJ" wrote:

I have cells with different dates when things come due. I want the cells to
change colors as the due dates get closer to todays date. Can anyone help me
with this formula?