Đã hoàn thành

Excel VBA for R1C1 Cell Formatting

I am looking to have a VBA code in excel that formats cell backgrounds (in as many colors as necessary) the various different R1C1 formulas on a given worksheet in excel. Each unique R1C1 code should color the background of cells with the same color. We want to be sure to ignore blank cells and cells with text (non formula cells). For cells that are hardcoded (values directly in cells) we should have a sepate color for. As part of this macro, we need a function that stores the current formatting (before running the macro) of the active sheet and an ability to go back to this original formatting. Finally, we will need this code to run on the sheet in no more than 3 seconds. On another note, I would like to own the rights to the code that you end up producing. If this is agreeable and you are capable of producing the code, please let me know what the estimated cost will be.



Kĩ năng: Excel, Excel VB Capabilities, Excel Macros, Excel VBA

Xem nhiều hơn: excel vba copy cell contents paste internet explorer, excel vba paste cell left, excel vba copy cell, excel vba paste cell, excel vba cut cell left right, excel vba export cell text, excel vba paste cell data, excel vba move cell contents, excel vba split cell macro, excel vba string cell split, excel vba split cell, excel vba extract cell comments, excel vba select cell by row and column number, excel vba format cell as date, excel vba copy cell value and paste to another cell, excel vba target cell reference, excel vba get cell address, excel vba replace cell value

Về Bên Thuê:
( 0 nhận xét ) Huntington, United States

ID dự án: #22230231

Được trao cho:


Hello Brian, I am an Excel expert from Vietnam. I have did many project on VBA and I can create this one for you. As your description, it will take maybe 1 day to do. Please contact me and send detail file. I need to Thêm

$100 USD trong 1 ngày
(142 Đánh Giá)

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


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g Thêm

$150 USD trong 1 ngày
(728 Nhận xét)

Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha Thêm

$150 USD trong 2 ngày
(311 Nhận xét)

Hello, I’m an Excel/VBA expert and I would like to help you with your macro. Please check my profile and contact me to discuss further details. Regards.

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

Dear client I am an excel expert and I have previously carried out a number of projects in excel in the past using macros and formulas. I can definitely help you in this project. Kindly contact me. Roy

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

Hi, As per requirements I will develop VBA macro for you as per description of the project. Please share your Excel sheet. I have expertise in Excel, formulas, Excel VBA and finished many such projects. Quality work w Thêm

$149 USD trong 4 ngày
(81 Nhận xét)

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Thêm

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

Hello, I am interested in your project. Your task is clear to me and I am ready to solve it. I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA. These Thêm

$100 USD trong 2 ngày
(85 Nhận xét)

Hello, ⭐⭐⭐⭐⭐ i am expert in this kind of jobs i can write the code for you to change cell's color based on RC values you can own the right of the code at the project's end samples of my excel programming jobs ⭐⭐⭐⭐⭐ Thêm

$40 USD trong 1 ngày
(44 Nhận xét)

Hello. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. A Excel Expert on freelancer.com and I do not bid on projects whic Thêm

$140 USD trong 1 ngày
(34 Nhận xét)

Hi. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps including many db formats: MS Access, MS SQL, SQL Thêm

$95 USD trong 2 ngày
(19 Nhận xét)

hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myse Thêm

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

It's a piece of cake for me Hi, sir Thank you for your job posting. I have enough experience with VBA, Excel, Data Processing. So, I am very confident to satisfy you absolutely. Let's achieve success together. Thank y Thêm

$100 USD trong 2 ngày
(6 Nhận xét)

I can do the job and I can start right away! In respect to storing current formating, a propose storing a "veryhiddensheet" which can only be unhidden- from code or a macro I would include. this will also be configurat Thêm

$100 USD trong 2 ngày
(16 Nhận xét)

Hi! Im ready to help you with the Macro /VBA solution. Please feel free to ask for a Draft version. Regards, Juan I am a entrepenour and Excel/VBA/Macro expert. I have extensive knowledge and expertise in advance Thêm

$40 USD trong 7 ngày
(2 Nhận xét)

Hi there, I read your requirements and understand very-well and ready to start work from now. Hope you give me a chance to do work with you. I hope you will be kind enough to consider me for your [login to view URL] forw Thêm

$40 USD trong 4 ngày
(4 Nhận xét)

Hello. How are you. I'm software engineer and algorithm expert. I have many experiences in Access, Excel, VBA. I can complete your project successfully. Thanks.

$140 USD trong 7 ngày
(1 Nhận xét)

I can start your project immediately. I can provide full-time communication and work your time-zone. If you give me a chance to serve you, I will provide a high quality product within the deadline. Best Regards

$100 USD trong 7 ngày
(0 Nhận xét)

Hello, Sir. I read your opinion seriously. I have experience of 7 years and done similar projects before. As a man of trust, I can develop your website with full perfection. Let me go on, you can get the best project t Thêm

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

I have experience with Excel VBA and different applications with it. I can create a quick macro for the operation you explained.

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

I have done macro vba programming to automate equipments and collect data including formatting and plotting in graphs. I can do that for you.

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