Validations in Excel

[sriramdh]

Hello Everyone,

I have a task monitoring workbook and need to put some validations in place. Tried a lot with all the amount of Excel i know, but unable to get these validations working:

1. All tasks much have estimated and actual start and finish dates.
2. If a task is WIP, completion % has to be entered
3. If task is WIP and completion % is < 50% and days left for completion is less than 50% of estimated completion date then comments need to be entered in Path to Green column

Have attached the structure below , thanks in advance for looking into this!

S.No Current Status Previous Status Priority Task Notes Owner Path to green Start Date Finish Date A Start Date A Finish Date % Completed E Finish Date Category 1 WIP WIP P1 AB T 2018-05-15 2018-06-25 2018-05-16 100 2 WIP P2 BC A 2018-05-30 2018-06-30 50 <colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> </tbody>

<tbody>
</tbody>

 

[sriramdh]

4. If a task is WIP, each owner can only assign Priority for three tasks

Thanks again everyone!