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 ...
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.