tennisbuck
New Member
- Joined
- Apr 29, 2013
- Messages
- 23
Hi Board,
On the attached spreadsheet, what would be the formula I can use to conditionally format cell E2 to yellow based on the following criteria:
1.) Cell C2=N
2.) Cell E2 is 305 days or greater then the hire date
Mike
<tbody>
</tbody>
On the attached spreadsheet, what would be the formula I can use to conditionally format cell E2 to yellow based on the following criteria:
1.) Cell C2=N
2.) Cell E2 is 305 days or greater then the hire date
Mike
Director | Hire Date | Media Fill Y/N | Date Required | 60 Days | Comments |
Mike | 8/23/2016 | N | 2/21/2017 | 6/21/2017 | |
<tbody>
</tbody>
Last edited: