Suoritettu

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.

Thanks,

Brian

Taidot: Excel, Excel VB Capabilities, Excel Macros, Excel VBA

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) Huntington, United States

Projektin tunnus: #22230231

Myönnetty käyttäjälle:

nvchien94

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 Lisää

$100 USD 1 päivässä
(142 Arvostelua)
5.9

21 freelanceria on tarjonnut keskimäärin 93$ tähän työhön

jaylancer43

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 Lisää

$150 USD 1 päivässä
(728 arvostelua)
8.5
schoudhary1553

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 Lisää

$150 USD 2 päivässä
(311 arvostelua)
7.9
P0L

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 1 päivässä
(324 arvostelua)
7.3
TonmoyRoy111

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 1 päivässä
(339 arvostelua)
6.9
TechnoGuruu

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 Lisää

$149 USD 4 päivässä
(81 arvostelua)
6.0
aubrey03

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] Lisää

$50 USD 1 päivässä
(131 arvostelua)
6.0
SShtv

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 Lisää

$100 USD 2 päivässä
(85 arvostelua)
6.0
Ahmed818

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 ⭐⭐⭐⭐⭐ Lisää

$40 USD 1 päivässä
(44 arvostelua)
4.4
StormLion227

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 Lisää

$140 USD 1 päivässä
(34 arvostelua)
4.8
writingapp

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 Lisää

$95 USD 2 päivässä
(19 arvostelua)
4.6
rIbrarahmed

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 Lisää

$40 USD 1 päivässä
(15 arvostelua)
4.4
michaels225

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 Lisää

$100 USD 2 päivässä
(6 arvostelua)
3.9
ielucerotrad1

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 Lisää

$100 USD 2 päivässä
(16 arvostelua)
4.0
emilianoreyes70

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 Lisää

$40 USD 7 päivässä
(2 arvostelua)
2.9
ravinderkumar248

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 Lisää

$40 USD 4 päivässä
(4 arvostelua)
1.9
Alexsfodik

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 7 päivässä
(1 arvostelu)
1.6
Albertbestcoder

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 7 päivässä
(0 arvostelua)
0.0
staratnight

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 Lisää

$120 USD 2 päivässä
(0 arvostelua)
0.0
hiroyigit

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

$90 USD 1 päivässä
(0 arvostelua)
0.0
kat1334

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 10 päivässä
(0 arvostelua)
0.0