Excel Formulas Help
I may be just having a brain malfunction or 2007 Excel and I are not
communicating effectively. I have to date ranges in one of my worksheets, colum X equals the date entered, colum Y = X +365 so I get a due date one year from the date entered in X. I would like to add some conditional formatting in colum X by having the cell highlighted when the current computer date is greater than what is in X. I am not getting the formula to work properly, any help out there? |
Excel Formulas Help
CF formula is:
=X2<TODAY() -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Michael" wrote: I may be just having a brain malfunction or 2007 Excel and I are not communicating effectively. I have to date ranges in one of my worksheets, colum X equals the date entered, colum Y = X +365 so I get a due date one year from the date entered in X. I would like to add some conditional formatting in colum X by having the cell highlighted when the current computer date is greater than what is in X. I am not getting the formula to work properly, any help out there? |
All times are GMT +1. The time now is 09:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com