Find Jobs
Hire Freelancers

Excel VBA for R1C1 Cell Formatting

$30-250 USD

Terminado
Publicado hace más de 4 años

$30-250 USD

Pagado a la entrega
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
ID del proyecto: 22230231

Información sobre el proyecto

18 propuestas
Proyecto remoto
Activo hace 4 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 1 día
5,0 (196 comentarios)
6,3
6,3
18 freelancers están ofertando un promedio de $89 USD por este trabajo
Avatar del usuario
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 en 1 día
4,9 (372 comentarios)
7,5
7,5
Avatar del usuario
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 en 1 día
4,9 (391 comentarios)
7,0
7,0
Avatar del usuario
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 en 4 días
5,0 (87 comentarios)
6,1
6,1
Avatar del usuario
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 en 1 día
4,8 (42 comentarios)
5,3
5,3
Avatar del usuario
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 en 2 días
4,8 (33 comentarios)
5,0
5,0
Avatar del usuario
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 en 1 día
4,7 (17 comentarios)
4,7
4,7
Avatar del usuario
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 en 1 día
5,0 (56 comentarios)
4,6
4,6
Avatar del usuario
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 en 2 días
5,0 (21 comentarios)
4,2
4,2
Avatar del usuario
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 en 7 días
5,0 (7 comentarios)
3,5
3,5
Avatar del usuario
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 en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have experience with Excel VBA and different applications with it. I can create a quick macro for the operation you explained.
$90 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 10 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Huntington, United States
5,0
5
Forma de pago verificada
Miembro desde jun 19, 2013

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.