Käynnissä

10 minute excel project for Expert - highlight alternating ID in column

Input: Excel sheet which will be sorted on a specific column

Example data and what to do to it

A10CLUSRQDKJBH

A10CLUSRQDKJBH

A10NF5TK6IFNX6 (colorize row)

A14ZYPRK2O4WIM

A14ZYPRK2O4WIM

A18VXKX5URAA4G (colorize row)

A18VXKX5URAA4G (colorize row)

A18VXKX5URAA4G (colorize row)

The goal is to give the user of the spreadsheet a visual break between sets of data

I'm not sure if this is a macro or a function.

In the included

Data tab: shows the output with every other group of data, by TargetID, highlighted

Function tab: shows parameters.

If done as a macro, I would see it working by highlighting the column and running the macro.

If possible, it should also work on google sheets

Do NOT colorize the blank cells past the end of columns of data

Taidot: Excel

Näytä lisää: excel project excel expert, excel project expert, excel teamviewer project expert formulas excel teamviewer, expert excel project, excel project bid template, peachtree excel project, excel project macro samples, excel project help needed, code project expert system, visual studio excel project, excel project task list, excel project manage template web design, excel macro expert india, excel project macro, simple excel project grade

About the Employer:
( 83 reviews ) Oconomowoc, United States

Projektin tunnus: #14818820

Myönnetty käyttäjälle:

dayakmlt

There is no macro or any special function in it, task completed, ready to deliver File is ready to deliver Relevant Skills and Experience Excel Proposed Milestones $20 USD - Excel Will deliver tomorrow

10 $ USD 1 päivässä
(12 arvostelua)
3.2

44 freelanceria on tarjonnut keskimäärin 20 $ tähän työhön

koolsidz

Easy job. The code is ready :) If you pm me then I can give you a demo. Relevant Skills and Experience My Credentials: 20+ of VB Experience. [url removed, login to view] [url removed, login to view] Lisää

10 $ USD 1 päivässä
(148 arvostelua)
6.5
avinav606lx

Hey There, I can do this quickly.I have code ready for this kind of work. Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/word/outlook VBA automation professional ha Lisää

25 $ USD 0 päivässä
(127 arvostelua)
6.3
paris2785

I've read your brief and can see that you'd like to have an Excel spreadsheet macro. Relevant Skills and Experience I have 7 years experience in designing and developing Excel spreadsheets filled with formulas and VB Lisää

14 $ USD 0 päivässä
(110 arvostelua)
6.4
Tanmoy236

I am extremely good with excel as it is part of my daily professional work. I am fast accurate and at the same time understand the value of quality and deadlines. I have already done 100 works on Freelancer where major Lisää

15 $ USD 1 päivässä
(89 arvostelua)
6.0
nagybatonyi

In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Relevant Skills and Experience I have a university degree in econo Lisää

25 $ USD 0 päivässä
(62 arvostelua)
5.7
25 $ USD 1 päivässä
(91 arvostelua)
5.7
MoohHHooM

Hi, i can help you with this project, so the idea is to change the highlight color when the text changes after sort consider it done :) .

25 $ USD 0 päivässä
(24 arvostelua)
5.3
sonarkaushik

Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. Lisää

29 $ USD 1 päivässä
(40 arvostelua)
5.6
Jeremiah1992

Contact me right now as I can start this project for you. Relevant Skills and Experience I have done several project similar to this one before. Proposed Milestones $20 USD - .

20 $ USD 0 päivässä
(11 arvostelua)
4.9
mail2vimalarora

Have gone throuhgh your excel project details of coloring alternative groups grouped by particular ID, and can take up task to complete it quickly and efficiently. Relevant Skills and Experience Well versed in excel f Lisää

30 $ USD 0 päivässä
(24 arvostelua)
4.7
asin1987

Respected Sir/Mam I will do any formula, function, formatting, calculation, modification, automation on Excel. PFA my previous automation works for reference. I hope to work with you. Thanks!! Relevant Skills and Exp Lisää

25 $ USD 1 päivässä
(13 arvostelua)
4.7
25 $ USD 1 päivässä
(15 arvostelua)
4.2
Zahidbabu

Please give me a ONE Chance to work with u. ****100% work grantee. Fast delivery** Hi Dear Honorable Concern It is my pleasure to introduce myself. I'm ZahidBabu Relevant Skills and Experience I have been doing Data Lisää

25 $ USD 1 päivässä
(13 arvostelua)
3.8
humayoonsheikh4u

A proposal has not yet been provided

30 $ USD 1 päivässä
(8 arvostelua)
4.0
ingluisroldan

I can help you in your requeriments, I´m expert in Excel, Magister in Business Intelligence. Habilidades y experiencia relevante I´m industrial engineer, specilist in data science and Magister in Business Intelligence Lisää

15 $ USD 0 päivässä
(4 arvostelua)
3.5
15 $ USD 1 päivässä
(5 arvostelua)
3.5
shakerhany

HI, I read the project description carefully, and checked the attachment, and I am ready to start working on it straight away, Relevant Skills and Experience I've more than 8 years of experience in creating and develo Lisää

30 $ USD 0 päivässä
(10 arvostelua)
2.9
zagitarious3k

Hi, I can do this through conditional formatting and some formulas. You can trust me for 100% accuracy and fast turnaround time. Relevant Skills and Experience I am an excel expert and I have all relevant skills and e Lisää

10 $ USD 0 päivässä
(8 arvostelua)
3.1
shahida772

I am expert in it and am confident I can meet and exceed your expectations. “I can complete your project within the [url removed, login to view] can be decided according to ur desire. Relevant Skills and Experience excel Proposed Mil Lisää

25 $ USD 1 päivässä
(4 arvostelua)
2.1
25 $ USD 3 päivässä
(2 arvostelua)
1.8