Create conditional formatting for excel file

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.

Compétences : Excel

en voir plus : create dat file excel, cells empty dont create file excel macro, create xml file excel, create xml file excel visual basic, create graph save file excel vba, create csv file excel, create chart csv file excel, excel 2003 conditional formatting, create iif file excel, create xml file excel vba

Concernant l'employeur :
( 0 commentaires ) Sri Lanka

Nº du projet : #8464041

39 freelance font une offre moyenne de $18/heure pour ce travail


A proposal has not yet been provided

$30 AUD / heure
(204 Commentaires)

I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. Please see reviews on my profile. It would be my pleasure to do your project. Please have a look at some Excel project Plus

$15 AUD / heure
(47 Commentaires)

Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India

$15 AUD / heure
(78 Commentaires)

Hi, I am good at excel and conditional formatting. Looking forward to work on this project. Plz provide me the excel workbook to work on. Plz have a look at my testimonials.

$18 AUD / heure
(75 Commentaires)

Dear Hiring Manager, I have gone through your job posting and become very much interested to work with you. I am an expert in these fields. I have already completed several projects like this. For evidence you can see Plus

$15 AUD / heure
(37 Commentaires)

Hi there My name is Redouane I am very interested in your project. Kindly start messaging so we can discuss further details. Thank you

$16 AUD / heure
(38 Commentaires)

I have the expertise in Excel and can use conditional formatting for your specifications and formulas where required.

$22 AUD / heure
(18 Commentaires)

I am a post graduate in Finance with more than one year of experience as a Financial Analyst. My work included: • Writing annual credit review reports for corporate and banks with a focus on competitive industry analy Plus

$15 AUD / heure
(11 Commentaires)

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

$17 AUD / heure
(4 Commentaires)

Dear, I am interested in your work. I also have expertise in excel. I done your work as per your requirement also within time and budget. Contact me. Thanks and Regards Asif

$15 AUD / heure
(17 Commentaires)

Hi, I am good in excel formulas. Please send me the excel sheet Please feel free to ask any questions. Regards Umesha

$16 AUD / heure
(12 Commentaires)

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 Plus

$22 AUD / heure
(1 Évaluation)

Professional Data Scientist and Excel Expert. More than 5 years of experience in handling complex data sets. Can finish this job in minutes.

$22 AUD / heure
(7 Commentaires)

Hello, in interesting into your project which match with my experiences. I placed bid for your consideration. I'm excel coder, with 3year+ experienced in excel coder & formulas I am very confident that i will deliv Plus

$15 AUD / heure
(3 Commentaires)

Hi I'm new on this site but I'm very skilled with excel, access, vba. I've already implemented 4 small project here, you can see my credentials. I'd like to work on your project. If you want, I can prepare the exce Plus

$15 AUD / heure
(9 Commentaires)

Hi, i want to work on this nice project' i want to work on this nice project i want to work on this nice project Thank You. Masud

$15 AUD / heure
(2 Commentaires)

I am a hard working, communicative, and dedicated person looking forward to be hired for any data entry, writing, or web development task. I have huge experience working as a data entry operator. You will find me very Plus

$16 AUD / heure
(4 Commentaires)

> Engineering Graduate, helps to think better. > Experienced person, helps to do better. > Worked in reputed organisation, suitable to work with employees. > Researcher, helps to innovate, develop and create new pos Plus

$20 AUD / heure
(0 Commentaires)

Предложение еще не подано

$15 AUD / heure
(0 Commentaires)

i'm professional , i do it every day for own project, it easy and simple, i don't know what should i say, i'm not good presenter , i just know that i could done it.

$22 AUD / heure
(0 Commentaires)