ExcelBanter - Date formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Date formatting (https://www.excelbanter.com/excel-discussion-misc-queries/229979-date-formatting.html)

Date formatting

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?

Gary''s Student

Date formatting

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?

All times are GMT +1. The time now is 06:17 PM.