I need to take the delta of a manually entered date in a cell and compare it to today's date. Then i need to set the cell or column a certain color depending on the value of delta -- positive, zero or negative.
That was exactly what i needed.Excel conditional formatting for dates & time: formulas and rules
See how to apply Excel conditional formatting to dates and time. How to use formulas to highlight weekends and holidays, format cells when a value is changed to a date, shade upcoming dates and delays, conditionally format dates based on the current date, and more.www.ablebits.com