Đang Thực Hiện

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

Kỹ năng: Excel

Xem thêm: 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

Về Bên Thuê:
( 83 nhận xét ) Oconomowoc, United States

Mã Dự Án: #14818820

Đã trao cho:

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 trong 1 ngày
(7 Đánh Giá)
2.5

45 freelancer đang chào giá trung bình $20 cho công việc này

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] Thêm

$10 USD trong 1 ngày
(147 Đánh Giá)
6.4
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 Thêm

$25 USD trong 0 ngày
(123 Đánh Giá)
6.2
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 Thêm

$14 USD trong 0 ngày
(108 Đánh Giá)
6.3
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 Thêm

$15 USD trong 1 ngày
(87 Đánh Giá)
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 Thêm

$25 USD trong 0 ngày
(61 Đánh Giá)
5.7
$25 USD trong 1 ngày
(85 Đánh Giá)
5.7
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. Thêm

$29 USD trong 1 ngày
(40 Đánh Giá)
5.6
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 trong 0 ngày
(22 Đánh Giá)
5.1
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 trong 0 ngày
(11 Đánh Giá)
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 Thêm

$30 USD trong 0 ngày
(24 Đánh Giá)
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 Thêm

$25 USD trong 1 ngày
(10 Đánh Giá)
4.4
$25 USD trong 1 ngày
(12 Đánh Giá)
4.0
humayoonsheikh4u

A proposal has not yet been provided

$30 USD trong 1 ngày
(8 Đánh Giá)
3.9
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 Thêm

$25 USD trong 1 ngày
(13 Đánh Giá)
3.3
$15 USD trong 1 ngày
(4 Đánh Giá)
3.4
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 Thêm

$10 USD trong 0 ngày
(8 Đánh Giá)
3.1
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 Thêm

$15 USD trong 0 ngày
(3 Đánh Giá)
3.1
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 Thêm

$30 USD trong 0 ngày
(10 Đánh Giá)
2.7
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 Thêm

$25 USD trong 1 ngày
(4 Đánh Giá)
2.1
$25 USD trong 3 ngày
(2 Đánh Giá)
1.8