Completed

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

Skills: Excel, Visual Basic for Apps

See more: 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, change format date excel macro, excel macro check text format, excel macro check data format, excel macro copy cell, excel macro copy date format

About the Employer:
( 9 reviews ) Riyadh, Saudi Arabia

Project ID: #16327408

Awarded to:

$10 USD in 1 day
(319 Reviews)
7.2

31 freelancers are bidding on average $16 for this job

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 More

$15 USD in 1 day
(3 Reviews)
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 in 1 day
(11 Reviews)
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 More

$10 USD in 0 days
(36 Reviews)
5.0
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 More

$10 USD in 1 day
(28 Reviews)
4.3
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 More

$29 USD in 1 day
(6 Reviews)
3.8
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 More

$10 USD in 10 days
(14 Reviews)
3.6
gsanggara

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

$10 USD in 0 days
(16 Reviews)
3.6
bbrutas

A proposal has not yet been provided

$10 USD in 0 days
(5 Reviews)
3.4
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 in 1 day
(6 Reviews)
3.2
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 More

$25 USD in 1 day
(5 Reviews)
3.2
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 in 1 day
(2 Reviews)
2.7
Nawaf2020th

طلبك اصبح جاهز وفقاً لمعطياتك ..................................................................................... ..................................................................................... your project More

$10 USD in 0 days
(1 Review)
1.1
anx1818

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

$10 USD in 2 days
(1 Review)
0.7
prashn2u2n

A proposal has not yet been provided

$15 USD in 1 day
(0 Reviews)
0.0
shahvimal

A proposal has not yet been provided

$10 USD in 2 days
(0 Reviews)
0.0
cristiancamilo88

A proposal has not yet been provided

$10 USD in 3 days
(0 Reviews)
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 in 1 day
(0 Reviews)
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 in 1 day
(0 Reviews)
0.0
savignesh

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

$10 USD in 1 day
(0 Reviews)
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 in 0 days
(0 Reviews)
0.0