Forum Discussion
change a cell based on dates from a data sheet in the same workbook
HansVogelaarIn your Formulas what does the 12 stand for?
I need to know 30 days or 1 month ahead as a warning and then when it is expired to show red. For one of my Drivers It shows red but nothing expires for 6 months.
It's slightly more complicated. See the attached version.
I used two defined names; you can view their definition in Formulas > Name Manager.
HansVogelaarI have tried the formulas over and over again.It doesnt seem to be working on My main Workbook. Ive attached what im working with and included the data minus the confidential stuff.
I will say I have only really been messing with Excel for about a year and it really has never been this in depth. This workbook we use to keep track of almost everything in our Trucking business. Every month I add a new tab and copy all this blank info into it. I would love to be able to use this same formula so and put it where it needs to go and that way no matter what month tab anyone is in they can see if any of our drivers has an issue.
Thank you for all the help btw. I kinda got it working before with just the first one. But then is was messed up on a guy and nothing was expired.
- I should Mention I am using Office 365 on a Mac. This is also a shared workbook.
1) Since your data on the December sheet begin in row 7, the defined names should be created while you're in row 7, and they should refer to December!$B7.
2) Since the name of the Driver Info sheet contains a space, you must enclose it in single straight quotes in formulas: 'Driver Info'.
3) Since the expiration dates are in columns J to L, and not in L to N as you stated in your first post, the column numbers in VLOOKUP must be {10,11,12} instead of {12,13,14}.
See the attached version.