Find Jobs
Hire Freelancers

Excel VBA for R1C1 Cell Formatting

$30-250 USD

Abgeschlossen
Veröffentlicht vor mehr als 4 Jahren

$30-250 USD

Bezahlt bei Lieferung
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
Projekt-ID: 22230231

Über das Projekt

18 Vorschläge
Remote Projekt
Aktiv vor 4 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
Vergeben an:
Avatar des Nutzers
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 check inside first. We can start right now if you want. Thanks.
$100 USD in 1 Tag
5,0 (196 Bewertungen)
6,3
6,3
18 Freelancer bieten im Durchschnitt $89 USD für diesen Auftrag
Avatar des Nutzers
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 Tag
4,9 (372 Bewertungen)
7,5
7,5
Avatar des Nutzers
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 Tag
4,9 (391 Bewertungen)
7,0
7,0
Avatar des Nutzers
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 with high accuracy and 100% customer satisfaction is guaranteed.I look forward to discussing the project with you and hopefully secure a long term working relationship. I am ready to work on this project now. Thanks and regards, Mohan
$149 USD in 4 Tagen
5,0 (87 Bewertungen)
6,1
6,1
Avatar des Nutzers
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 which I am not sure. I will not disappoint you and I will do my best for give you a perfect solution. If I have an opportunity to work with you, That's my pleasure. No milestones required in advance, please pay me once the job is 100% complete. Also, before you consider awarding me the project, I can provide you with some sample files via your requirements. Please message me, so we can discuss here as I may have some questions. Thank you. Marko R.
$140 USD in 1 Tag
4,8 (42 Bewertungen)
5,3
5,3
Avatar des Nutzers
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 Server, MySQL, SQLite, PostgreSQL, Firebird Write Automation apps including: * Automation Desktop apps. Some examples: Automation Playing Games, Automation Start/Stop/Click 3rd party apps * Automation Web apps. Some examples: Automation Web Scraping apps, Automation Web Crawling apps * Automation Data Processing apps: Automation formatting data to a specified template * Automation Data, Document Converting apps * Automation Macro, VBA for all apps in MS Office (Excel, Word, Outlook), OpenOffice, GoogleSheet * Automation Installers/Setups * Convert your Manual tasks to Automation solutions Write Web Service, Web API, Desktop API apps. Some examples: Google API, Bing API, Facebook API, MS API Fix/Solve any errors in your OS, apps
$95 USD in 2 Tagen
4,8 (33 Bewertungen)
5,0
5,0
Avatar des Nutzers
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 myself for this project. please contact with me. Thanks.
$40 USD in 1 Tag
4,7 (17 Bewertungen)
4,7
4,7
Avatar des Nutzers
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 ⭐⭐⭐⭐⭐ https://www.freelancer.com/projects/excel/Create-Excel-Spreadsheet-Macro-that/ https://www.freelancer.com/projects/excel/Make-VBA-code-run-itself/ https://www.freelancer.com/projects/visual-basic/Retrieving-data-from-other-different/ https://www.freelancer.com/projects/Excel/Multiple-Entry-Excel-Macro/ https://www.freelancer.com/projects/Excel/VBA-loop-code-sum/ https://www.freelancer.com/projects/Excel/Complete-Some-Advanced-VBA-Microsoft/ https://www.freelancer.com/projects/Data-Entry/Capture-data-from-website-website-12641885/ ⭐⭐⭐⭐⭐ waiting your answer Regards
$40 USD in 1 Tag
5,0 (56 Bewertungen)
4,6
4,6
Avatar des Nutzers
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 configuration sheet for color coding. As for speed issue, depends on amount of cells in coloring range (how many rows and columns are expected?) No problem with rights, will right original code with no recycled parts. About me: I'm an engineer with advanced working knowledge and experience (over 15 years) in Microsoft Excel and VBA including interaction between different software (Word, Excel, Powerpoint, Access, Outlook, MS Project,MS Visio, Autocad, pdf, CorelDraw, PhotoShop, etc.). Also on web scraping, Access DB design, management Dashboards, stock and financial worksheets, KPI's, proficient coder in VB.Net, C#, Python, JavaScript (google sheets), VB6, AI (neural networks, genetic algorithms, optimized search, etc).
$100 USD in 2 Tagen
5,0 (21 Bewertungen)
4,2
4,2
Avatar des Nutzers
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 advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts (script).
$40 USD in 7 Tagen
5,0 (7 Bewertungen)
3,5
3,5
Avatar des Nutzers
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 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tagen
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von UNITED STATES
Huntington, United States
5,0
5
Zahlungsmethode verifiziert
Mitglied seit Juni 19, 2013

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.