Hi there
I am quite a newbie with macros but I think this is not going to be easy to you.
I have and excel file with two sheet in it.
In the first sheet there is a cell that contains a date.
The second sheet is where all the churn is. Please see image attached.image.JPG
If the month where each cell of all 3 ranges is equal or greater than the date referred in the first sheet then I want:
a) to be filled in with a particular color.
b) to be unlocked.
What do you reckon? Is it doable?
Any answers will be appreciated.
Thanks in advance.
M.
Bookmarks