Fermé

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 : Copie Dactylograghiée, Saisie de Données, Traitement de Données, Excel, Word

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 ) guwahati, India

N° du projet : #8450637

37 freelances ont fait une offre moyenne de 18 $ /heure pour ce travail

zExcel

A proposal has not yet been provided

31 $ AUD / heure
(205 Commentaires)
7.2
bizwizz

Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have b Plus

20 $ AUD / heure
(12 Commentaires)
5.3
AlexandrK1

A proposal has not yet been provided

22 $ AUD / heure
(13 Commentaires)
4.5
surekash7096

I have the expertise in Excel and can do the task as per the given instructions accurately. Ready to start work immediately.

22 $ AUD / heure
(19 Commentaires)
4.1
slenders13

Dear client, I have a lot of experience with VBA and Excel. I can complete the project without any problems Send me a message for more information. Kind regards, Rens Slenders

15 $ AUD / heure
(7 Commentaires)
3.3
ahmedfakkar

Dear, I have read your project and I am interested in working in. I a great experience in Excel especially Excel formulas & macros. I can show you samples of what I did before. let me know if you are interested Reg Plus

16 $ AUD / heure
(2 Commentaires)
3.0
remisanonymous

Hi, you not attached you example file. Can you attach it now? I can review it and make some formulas or VBA macro for right formatting. Best regards, Remis

15 $ AUD / heure
(3 Commentaires)
2.3
prolinkerx

A proposal has not yet been provided

15 $ AUD / heure
(1 Commentaire)
1.8
gsanggara

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)
1.1
swethadeva16

Hi this is swetha.. I am very much interested to work in excel.I will try to give 100% dedication and completion towards the [url removed, login to view]

17 $ AUD / heure
(0 Commentaires)
0.0
sabhadridham

I am hardworking and looking forward to do the work for my employee in best way and looking for work long term as well as short term

22 $ AUD / heure
(0 Commentaires)
0.0
manojkumar425

Hi this is Manoj Kumar , I am a new Freelancer working as a Software Engineer in a good and reputed company, looking to work eagerly on new things. I will most probably work on weekends and an average of 5 to 6 hr Plus

15 $ AUD / heure
(0 Commentaires)
0.0
anasocol

A proposal has not yet been provided

16 $ AUD / heure
(0 Commentaires)
0.0
simerdeep80

Hello, I am a computer engineer and good at all sort of computer related work related to data entry,editing,converting a file from one form to another,creating graphs,manipulating the data.I have around 10 yrs of expe Plus

20 $ AUD / heure
(0 Commentaires)
0.0
bhanujasrotia90

Gurah Jattan Mandi, Village and post office Ghagwal, District and Tehsil Samba, Jammu and Kashmir 184141 INDIA Mb: +919596885143, +919419220582 BHANU PARTAP SINGH Plus

17 $ AUD / heure
(0 Commentaires)
0.0
tonycorreia

A proposal has not yet been provided

20 $ AUD / heure
(0 Commentaires)
0.0
NancyHong

A proposal has not yet been provided

22 $ AUD / heure
(0 Commentaires)
0.0
verzox

A proposal has not yet been provided

22 $ AUD / heure
(0 Commentaires)
0.0
harshadmaloo

A proposal has not yet been provided

16 $ AUD / heure
(0 Commentaires)
0.0
preetkaur001

I can handle this type of work. Hope you will revert me for this work. I am good in this work because i have handle this work in my routine work. Thank you.

22 $ AUD / heure
(0 Commentaires)
0.0