Hi freelancers, in the attached file I want a VBA code to do the following:
Check all cells from W37 to the "last row" in the sheet. If any cell in that range contain date less than 1-1-2018 , the next two cells in the same row must be protected. For example cell W40 in the attachment has the date 22-Sep-2017, then cells Y40 and AA40 must has the format protection locked. Cell W38 has the date 03-Jun-2019, then cells Y40 and AA40 must has the format protection NOT locked.
I'll pay only USD 10 for this small project, please if you want more money don't bid :)