HerrUther
New Member
- Joined
- Sep 3, 2014
- Messages
- 7
Hello all,
I'm trying to create a spreadsheet to track assessments on personnel.
I've created a list of columns that use the formula =IF(E46="","",DATE(YEAR(E46),MONTH(E46)+12,DAY(E46))) to auto calculate the next date for assessment this one is for the 12 monthly reviews. I've also added conditional formatting that changes the date to orange 60 days before expiry and red once expired.
These dates continue to run and what I'm trying to achieve is a some kind of conditional formatting or something else of something that changes the expired date colour to 'No formatting' once the next date field is completed.
Sorry for the lack of pictures...
I'm using excel 2010 and I'm a very basic user so please keep it simple
I'm trying to create a spreadsheet to track assessments on personnel.
I've created a list of columns that use the formula =IF(E46="","",DATE(YEAR(E46),MONTH(E46)+12,DAY(E46))) to auto calculate the next date for assessment this one is for the 12 monthly reviews. I've also added conditional formatting that changes the date to orange 60 days before expiry and red once expired.
These dates continue to run and what I'm trying to achieve is a some kind of conditional formatting or something else of something that changes the expired date colour to 'No formatting' once the next date field is completed.
Sorry for the lack of pictures...
I'm using excel 2010 and I'm a very basic user so please keep it simple