Đã hoàn thành

Excel macro to change cell format

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 :)

Kĩ năng: Excel, Visual Basic cho Ứng dụng

Xem nhiều hơn: excel vba format cell color, excel vba numberformat percentage, excel vba set cell format to date, excel vba numberformat currency, vba cell format text, excel vba numberformat accounting, excel vba format cell border, excel vba format number decimal places, excel macro javascript date format issue, excel macro cell format data, excel macro format cell, excel macro clipboard pasting format, excel csv change date format, excel macro cell format check, excel macro validate date format

Về Bên Thuê:
( 8 nhận xét ) Riyadh, Saudi Arabia

ID dự án: #16327408

Được trao cho:

$10 USD trong 1 ngày
(284 Đánh Giá)
7.1

32 freelancer đang chào giá trung bình $16 cho công việc này

dotsys123

Dear Sir/Madam, Thank you for reading my proposal. I am expert in Admin support, Customer support, eCommerce product listing, Online Marketing and Web Development services . I have following experience of work wh Thêm

$15 USD trong 1 ngày
(3 Nhận xét)
5.5
nadimvicky

My work is to prepare design calculation in excel.I have good knowledge of excel and I am good in mathematics.

$15 USD trong 1 ngày
(11 Nhận xét)
5.0
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered ten excel vba projects in the past two months. Willing to take up your project. Thank you, Regards. Ok. I am doing it for a nice 5 o Thêm

$10 USD trong 0 ngày
(26 Nhận xét)
4.8
chintuag

Dear Hiring Manager, I am an expert in excel and have worked on various automation projects. My skills includes, but not limited to: Macros, Web Scraping, User Forms, Dashboards, Pivot Tables, Formulas, Customized Ri Thêm

$29 USD trong 1 ngày
(6 Nhận xét)
3.8
sloker18

I have read your requirement that you want to protect certain cells based on the value of another cell, I am proficient in using excel macro and VBA, the requirement can be finished within one day. Await for your preci Thêm

$10 USD trong 1 ngày
(18 Nhận xét)
3.9
gsanggara

Hello Khled, I have done your project, please award the project to me if you need it. Thank & Regards, gs_anggara

$10 USD trong 0 ngày
(16 Nhận xét)
3.6
lherreraz

I have a large experience working with advanced Excel and Macros using VB, the most important thing is that I can do the job, quickly and well done. Please, contact me and let's talk about how can I help for your proje Thêm

$10 USD trong 10 ngày
(7 Nhận xét)
3.0
imranrazawi

I am experienced Excel VBA developer. I can apply the vba code according to your needs as in descriptions. I have very good skills and big experience.

$25 USD trong 1 ngày
(5 Nhận xét)
3.2
bbrutas

A proposal has not yet been provided

$10 USD trong 0 ngày
(3 Nhận xét)
2.4
liangjongai

I can work for you. I'm interested in your project. I've an experience of works with excel macro. Ping me any time to discuss about this project.

$50 USD trong 1 ngày
(1 Nhận xét)
2.5
sysdesigner13

Hello. I have read your description carefully and understand it well. I am a full time developer and have high skills in VBA . I have already completed a lot of similar projects in the past. I think your pr Thêm

$25 USD trong 1 ngày
(2 Nhận xét)
1.8
anx1818

Hi, I can give you the code in half an hour. Please message me

$10 USD trong 2 ngày
(1 Nhận xét)
0.7
Rizal258

A proposal has not yet been provided

$15 USD trong 2 ngày
(0 Nhận xét)
0.0
madhukar1618

I am assuming that you have written all your requirements and you are not looking for any additional functionality or flexibility.

$10 USD trong 1 ngày
(0 Nhận xét)
0.0
cristiancamilo88

A proposal has not yet been provided

$10 USD trong 3 ngày
(0 Nhận xét)
0.0
Group001

hi,i am new freelancer but having much experience related to your [login to view URL] can visit my portfolio to see my recent work. Thanks for reading me.

$10 USD trong 1 ngày
(0 Nhận xét)
0.0
smartservices20

Dear sir, I am data entry and web search expert and can do for you as well. Please send message for details. Thanks

$15 USD trong 1 ngày
(0 Nhận xét)
0.0
savignesh

Hi....I'm ready to do this at low bid ..... give me the chance, I will do my best..........................

$10 USD trong 1 ngày
(0 Nhận xét)
0.0
lucasmecanica

Please, if you accept it tell me if the cells to be checked are only in the W column. thanks and have a nice day.

$10 USD trong 0 ngày
(0 Nhận xét)
0.0
amauripereira

A proposal has not yet been provided

$15 USD trong 2 ngày
(0 Nhận xét)
0.0