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.



Skills: Excel, Excel VB Capabilities, Excel Macros, Excel VBA

See more: 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

About the Employer:
( 5 reviews ) Huntington, United States

Project ID: #22230231

Awarded to:


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 More

$100 USD in 1 day
(196 Reviews)

18 freelancers are bidding on average $89 for this job


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 and have been featured by the freelancer community (g More

$150 USD in 1 day
(761 Reviews)

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 More

$150 USD in 2 days
(338 Reviews)

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 in 1 day
(372 Reviews)

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 in 1 day
(391 Reviews)

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] More

$50 USD in 1 day
(161 Reviews)

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 More

$149 USD in 4 days
(87 Reviews)

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 More

$100 USD in 2 days
(92 Reviews)

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 and I do not bid on projects whic More

$140 USD in 1 day
(42 Reviews)

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 More

$95 USD in 2 days
(33 Reviews)

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 ⭐⭐⭐⭐⭐ More

$40 USD in 1 day
(56 Reviews)

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 More

$40 USD in 4 days
(26 Reviews)

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 More

$100 USD in 2 days
(21 Reviews)

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 More

$40 USD in 1 day
(17 Reviews)

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 More

$40 USD in 7 days
(7 Reviews)

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

$90 USD in 1 day
(0 Reviews)

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 in 7 days
(0 Reviews)

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 in 10 days
(0 Reviews)