VBA for task tracker

Hi everyone,

So I'm doing a task tracker for myself since I keep forgetting to do certain things. I have a template I'm happy with, now I need 3 VBA macros to finish it off.

1st.

I need a macro that will automatically choose from drop down list a specific value in cells O2 to O220; if cell B2 to B220 has something in it. Normally I would do it via =IF(O2="", "OPEN", "")
but since it's a drop down it won't let me do this. This means that whenever I input a date to cells "O" the row becomes active as an open issue I'm tracking.

2nd.

I have a date in cells "B" which I populate. I have deadline in cells "L" according to max. days for resolution in cells "K".
Example: B2 = 15/05/19, K2 = 30, L2 = 14/06/19

Now to the macro: If I finish this task, I want to close it in cell "O" as stated above, and if I do this, I want the whole row to have a strikethrough and all cells that have a date in it to say "CLOSED" so the task will become inactive

3rd.

In column M I have remaining days. From this I want excel to send me a mail whenever remaining days reach certain amount, let say 10 or less. Is this possible?

If the file is needed I can provide it, but I would have to modify it since it contains confidential data atm.


Thanks