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!
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][TABLE="width: 1644"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]S.No[/TD]
[TD]Current Status[/TD]
[TD]Previous Status[/TD]
[TD]Priority[/TD]
[TD]Task[/TD]
[TD]Notes[/TD]
[TD]Owner[/TD]
[TD]Path to green[/TD]
[TD]Start Date[/TD]
[TD]Finish Date[/TD]
[TD]A Start Date [/TD]
[TD]A Finish Date[/TD]
[TD]% Completed[/TD]
[TD]E Finish Date[/TD]
[TD]Category[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]WIP[/TD]
[TD]WIP[/TD]
[TD]P1[/TD]
[TD]AB[/TD]
[TD] [/TD]
[TD]T[/TD]
[TD] [/TD]
[TD]2018-05-15[/TD]
[TD]2018-06-25[/TD]
[TD]2018-05-16[/TD]
[TD] [/TD]
[TD]100[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]WIP[/TD]
[TD] [/TD]
[TD]P2[/TD]
[TD]BC[/TD]
[TD] [/TD]
[TD]A[/TD]
[TD] [/TD]
[TD]2018-05-30[/TD]
[TD]2018-06-30[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]50[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[sriramdh]

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

Thanks again everyone!