Forum Discussion
change a cell based on dates from a data sheet in the same workbook
I have a data sheet with all my employees listed and it has their expiration dates from drivers license, med card and MVR expiration. Is there a way I can highlight a cell on other worksheets in the ...
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.
- Thank you for the help. The Driver Info was the part that was messing me up. I did not know it had to have the single straight quotes when there is a space in the name. The date colums i had changed before i realized the numbers called for the columns. I was thinking the formula would see the older date of hire and date of birth. I had that part fixed just after i posted my last reply.
Again thank you for the help.