Find Jobs
Hire Freelancers

Create conditional formatting for excel file

$15-25 AUD / hour

Cerrado
Publicado hace más de 8 años

$15-25 AUD / hour

Required: 1. Highlight rows containing multiple copies of a particular invoice number. eg an invoice's details may be display on 2 or 3 rows. These rows will be highlighted in light blue. Alternate groups of rows need to be highlighted a different colour (see examples attached eg Row 2 has the invoice displayed only once so requires no highlight, Rows3-4 has the invoice displayed 2 time, rows 5-7 has the invoice 3 times. ) In column H the total products value for that invoice number is required displayed on the last row containing that particular invoice number. The formula/rule will be needed so that it can applied to new worksheets or clear instructions provided on how to implement the necessary formulas.
ID del proyecto: 8440405

Información sobre el proyecto

50 propuestas
Proyecto remoto
Activo hace 9 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
50 freelancers están ofertando un promedio de $19 AUD /hora por este trabajo
Avatar del usuario
Hi, This is Santhosh from India. I am a Business Management Graduate with Computer Science engineering background who is passionate about Data, Mathematics and Technology. I have worked in few data analytics projects involving SAS & R. Also I have worked on many projects involving Excel (Pivot Table, Macros) and VBA. I am relatively new to freelancing so I don't have many projects to showcase in this site. I believe I have enough expertise to complete this project as per your requirement. I am sure that you will be 100% satisfied with my work. Please get in touch. Looking forward to hear from you. Thanks & Regards, Santhosh Kanna
$16 AUD en 3 días
5,0 (38 comentarios)
5,7
5,7
Avatar del usuario
Dear Sir/Madam, I have 12 years of experience in data processing and analysis using Excel, including conditional formatting. I'm immediately available and will provide quick turnaround. Please contact me to discuss project details. Thank you!
$17 AUD en 2 días
5,0 (65 comentarios)
5,4
5,4
Avatar del usuario
A proposal has not yet been provided
$22 AUD en 10 días
4,5 (65 comentarios)
5,3
5,3
Avatar del usuario
Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. It's a typical Access/Excel integration task. I'm very strong in solving these type of problems. Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$22 AUD en 3 días
4,7 (18 comentarios)
5,3
5,3
Avatar del usuario
Dear, I am interested in your work. I done your work as per your requirement also within time and budget. Contact me. Thanks and Regards Asif
$15 AUD en 2 días
5,0 (34 comentarios)
4,4
4,4
Avatar del usuario
Dear Sir/Mam, I'm Karthikeyan, Chennai City (India) into Data Processing, MS Excel Calculations & MS Powerpoint Presentations for the last 5 years. I have a team of 20 data entry operators and excel analysts. I can be your vendor to fulfill your processes with my team as part of your work if required after you get satisfied with our first commitment. I assure you that our services can compliment your portfolios to your clients for your effective reachout. We can chat elaborately if required. Looking forward to start your work right away. Thanks & Regards K. Karthikeyan
$15 AUD en 50 días
5,0 (8 comentarios)
3,3
3,3
Avatar del usuario
Professional Data Scientist and Excel Expert. More than 5 years of experience in handling complex data sets. can finish this job in minutes.
$16 AUD en 3 días
4,9 (7 comentarios)
3,4
3,4
Avatar del usuario
Greetings! Firstly I would like to mention about the task/Project, I can do this VERY EASILY. And I will prepare a template for you where you just need to refresh after adding the data. I can do the job on daily basis or can just prepare the template if you wish to do it for yourself. I can explain you in detail if you can begin the chat. I also take this opportunity to introduce myself as a highly talented Accountant and Analyst with strong technical knowledge and with an experience in the areas of Accounting, Algorithm, Audit and Business Analysis With the Degrees in Engineering and MBA, I am specialized in Logical approaches and simplifying day to day business processes. With specialization in Excel and other Microsoft Office tools, I can provide the best reports merging different data from different reports exported from the software. If you need Customer/Vendor/Stock Analysis incorporating all data from different reports, then just hire me Sending customized mails or printing customized letters using Mail merge, or Business Reporting and Analysis or Presentations or Documentation of Reports or preparing some daily used templates like Invoice , I am one of the finest choices you can have. If your software cannot give you the right FIFO / LIFO adjustments for stocks and bills adjustment and you need ageing reports or bill wise adjustment for issuing Discounts, then I am the best choice Give me an opportunity and trust me you will not regret it.
$15 AUD en 4 días
5,0 (1 comentario)
3,2
3,2
Avatar del usuario
Dear Client, Greetings! I am interested to your project .Mainly I am expert in data entry related work, Email marketing and quite good at Internet research, M.S.Word. , M.S.Excel. I am also good communicator in English and having enough typing speed WPM-40. If you give the valuable opportunity I will provide my best with accuracy work However Clint satisfaction is my first priority. I am also interested to work with you in future so hired me. Wait for your nice response Thank you Regards IMRAN SHEIKH
$16 AUD en 30 días
5,0 (28 comentarios)
2,2
2,2
Avatar del usuario
Hi, I'm new on thi site, but i'm very skilled in xls, access, vba. I've already implemented some simple project, you can check my references. I'd like to work on your project, and if you want you can send me the file, so that i can prepare the final delivery before the end of the bid: you will see what will you pay for. Just contact me. Hope to see your message, best regards Andrea
$15 AUD en 1 día
4,8 (10 comentarios)
2,5
2,5
Avatar del usuario
Hello. I'm understand how to do this job. Skills in VBA, experiance of working in excel, access two years. No problem with this job and those tasks from discription. See my portfolio. Good luck and succeed in this project.
$15 AUD en 5 días
4,3 (5 comentarios)
2,8
2,8
Avatar del usuario
Greetings! This is Ghulam Sabir. I am an MBA and have 5 years profession working experience and excellent skills at Ms Office (excel, word, power point). i have a similar project at my profile pls review and i hope you like it. I can do your task in minimum cost as i am new to this site and right now my priority is to get good reviews and recommendations rather than money. I assure you 100% quality work and at very low cost and as per committed date. Kindly contact me if you are interested and trust me you wont regret it Thanks Ghulam Sabir
$17 AUD en 1 día
5,0 (11 comentarios)
1,8
1,8
Avatar del usuario
এখনও কোন প্রস্তাব দেওয়া হয়নি
$15 AUD en 3 días
5,0 (2 comentarios)
1,1
1,1
Avatar del usuario
I have around 10 years of experience in Microsoft Technologies. I am aware of all the tools, techniques and formula's related to MS excel. The output produced would be of high quality standards.
$22 AUD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, I am well versed with the use of excel. I will use my experience to create an excel file for you that meets all you conditions and responds to commands as required.
$22 AUD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$22 AUD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Dear Sir, I have years of experience in excel and very good attention to details. I can complete the job and deliver the project on a timely manner. Regards,
$22 AUD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
should be straight forward. Will give it at the lowest bid amount
$16 AUD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, At Hermes Consultants we have staff working with varied skills. We have programers and developers, Content writers and more. Our staff have good grip on Ms Officer and specially in Ms Excel. We ensure you to deliver the best of qulaity and well in time work. We over others have advantage of work force. We would not deploy one but a WHOLE team for your project to get you best quality and work done in least time. We look forward to work with you. Regards Team Hermes
$17 AUD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$20 AUD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de SRI LANKA
Gampaha, Sri Lanka
0,0
0
Miembro desde sept 2, 2015

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.