Hi guys,
Could any one please help me write a vba for counting days from a start date entered in column A. Column B is formula'=TODAY()-B' . Column C is a list (Pending,Documentation,Completed) . What I need is column B should stop counting but retain the number as column C is populated as 'Completed'.
It would be appreciated column B changes colour to green
Thanking you in advance
Could any one please help me write a vba for counting days from a start date entered in column A. Column B is formula'=TODAY()-B' . Column C is a list (Pending,Documentation,Completed) . What I need is column B should stop counting but retain the number as column C is populated as 'Completed'.
It would be appreciated column B changes colour to green
Thanking you in advance