Find Jobs
Hire Freelancers

Create conditional formatting for excel file

$15-25 AUD / hour

Closed
Posted over 8 years ago

$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.
Project ID: 8440405

About the project

50 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
50 freelancers are bidding on average $19 AUD/hour for this job
User Avatar
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 in 3 days
5.0 (38 reviews)
5.7
5.7
User Avatar
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 in 2 days
5.0 (65 reviews)
5.4
5.4
User Avatar
A proposal has not yet been provided
$22 AUD in 10 days
4.5 (65 reviews)
5.3
5.3
User Avatar
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 in 3 days
4.7 (18 reviews)
5.3
5.3
User Avatar
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 in 2 days
5.0 (34 reviews)
4.4
4.4
User Avatar
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 in 50 days
5.0 (8 reviews)
3.3
3.3
User Avatar
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 in 3 days
4.9 (7 reviews)
3.4
3.4
User Avatar
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 in 4 days
5.0 (1 review)
3.2
3.2
User Avatar
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 in 30 days
5.0 (28 reviews)
2.2
2.2
User Avatar
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 in 1 day
4.8 (10 reviews)
2.5
2.5
User Avatar
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 in 5 days
4.3 (5 reviews)
2.8
2.8
User Avatar
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 in 1 day
5.0 (11 reviews)
1.8
1.8
User Avatar
এখনও কোন প্রস্তাব দেওয়া হয়নি
$15 AUD in 3 days
5.0 (2 reviews)
1.1
1.1
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$22 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
should be straight forward. Will give it at the lowest bid amount
$16 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$20 AUD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SRI LANKA
Gampaha, Sri Lanka
0.0
0
Member since Sep 2, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.