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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
VBA - compare a date manually entered in cell to today's date
- Thread starter Lyons900
- Start date
alansidman
Well-known Member
- Joined
- Feb 26, 2007
- Messages
- 8,110
- Office Version
- 365
- Platform
- Windows
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.
Upvote
0
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
Thank you!!
Upvote
0
