Hello everybody,
I am currently managing a database full of stock quantities, here:

Is there any way (I imagine some VBA coding) in which I can create a column 3 rows to the right of this one (row L in this case), where every single cell in row L would count the last time (in date, so for example: 05-08-2020 15:11) that the number in row I changed?
I want to do this to keep a check of my quantity and see if some of it doesn't move for longer periods of time (such as 3 months or more for example)
On top of this it would also be amazing if I could somehow create some sort of conditional formatting in row L, so whenever the date is more than 3 months old from the current date it turns to a red fill in the background - if this is possible too?
If anybody can help me create this it would be absolutely amazing! Thank you so much everybody
Best regards,
David
I am currently managing a database full of stock quantities, here:
Is there any way (I imagine some VBA coding) in which I can create a column 3 rows to the right of this one (row L in this case), where every single cell in row L would count the last time (in date, so for example: 05-08-2020 15:11) that the number in row I changed?
I want to do this to keep a check of my quantity and see if some of it doesn't move for longer periods of time (such as 3 months or more for example)
On top of this it would also be amazing if I could somehow create some sort of conditional formatting in row L, so whenever the date is more than 3 months old from the current date it turns to a red fill in the background - if this is possible too?
If anybody can help me create this it would be absolutely amazing! Thank you so much everybody

Best regards,
David