Conditional Formatting

Completed Posted 7 years ago Paid on delivery
Completed Paid on delivery

I have a excel spread sheet. Windows Ten, Libre Office Spreadsheet, closest to excel 10. In this I have three columns. One is text with name of business, second column are numbers and third column are numbers. I have thousands of such line items. I want that identical numbers in two different columns with the same name of business should be highlighted. Identical numbers are in altogether different rows.

Example:

A B C

Danny 100 0

Manny 0 100

Danny 0 100

Manny 0 100

Danny 100 0

Rows Danny 100 0 and Danny 0 100 should get highlighted, the first two only . If same number is there is same same column again no highlighting.

I also want detailed steps on how this is done. Please give a formal quotation for the work and the detailed description on how to do this.

Excel

Project ID: #10628596

About the project

26 proposals Remote project Active 7 years ago

Awarded to:

engrsiraj

Hi, I can do this and will inform you with the procedure as well. Waiting for your reply. Thanks....

₹600 INR in 1 day
(1 Review)
1.4

26 freelancers are bidding on average ₹1092 for this job

katilinas

I CAN do this job, and do it well! My repeat hire rate is 46 %. I always do my best to deliver a great work. If you look at my portfolio you will see that my skills are a good fit. Do You need a freelancer who can fulf More

₹950 INR in 1 day
(106 Reviews)
6.2
prateekmittal16

Hi I am a finance professional and have knowledge of various features of Excel. I know how to do conditional formatting and will provide a quick turnaround with step by step guide

₹1150 INR in 1 day
(1 Review)
3.0
tandonshailendra

Understand you want combination of three columns to be identified for duplication. Example "Danny 100 0" and "Danny 100 0) are duplicate. Evidently you need a macro which would concatenate three columns and mark dupli More

₹1000 INR in 1 day
(9 Reviews)
3.6
cahatimbattiwala

Please visit the profile for further information.

₹900 INR in 1 day
(1 Review)
2.2
qamartayyaba

A proposal has not yet been provided

₹850 INR in 3 days
(0 Reviews)
0.0
karmendra01

done in one day

₹600 INR in 1 day
(0 Reviews)
0.0
rohan24692

Expert in excel... Can start right away with this and deliver good quality work within deadlines. Look forward to work with you

₹850 INR in 1 day
(0 Reviews)
0.0
monicamohankumar

I am a chartered accountant having experience from Ernst and Young. My skill sets include auditing, accounting and taxation. I am proficient in excel and I can assure you the quality and timeliness of the work done wil More

₹1050 INR in 1 day
(0 Reviews)
0.0
PayyoliAngadiPO1

Sir, I am a new freelancer but registered years ago when I was in Government Service as Full time typist under contract basis. Now I focused here for more time to offer my service for required clients. I am in More

₹650 INR in 1 day
(0 Reviews)
0.0
hottyrobin28

I have more than 5 years on experience in KPO filed, where we perform several conditional formatting daily. I can also give you step by step explanation of this work

₹850 INR in 1 day
(0 Reviews)
0.0
uzairhashmi17

I have the right combination of skills and experience for this job. I also bring the additional quality of strong analytical and problem solving ability as shown by my introduction of a more efficient work flow system More

₹1550 INR in 1 day
(0 Reviews)
0.0
rakeshrj2016

Hii, i am very well in terms of excel work, i know many formulas which can your work easy in less time....

₹1300 INR in 1 day
(1 Review)
0.0
rondalle

A proposal has not yet been provided

₹1300 INR in 1 day
(0 Reviews)
0.0
devdasjacob

A proposal has not yet been provided

₹1750 INR in 2 days
(0 Reviews)
0.0
cahiteshaggarwal

We are a group of chartered accountants , running a small BPO, doing all types of Data processing services

₹1300 INR in 1 day
(0 Reviews)
0.0
hatemhbh

A proposal has not yet been provided

₹899 INR in 1 day
(0 Reviews)
0.0
muhammadimran95

Being an expert in excel, this is not at all a difficult task for me. I can do it for you in a day and also explain all the steps in doing the task so that you can do it your self the next time. Thank you.

₹1300 INR in 1 day
(0 Reviews)
0.0
natashislam

A proposal has not yet been provided

₹750 INR in 1 day
(0 Reviews)
0.0
loayrokay

Deliver on 2 days max

₹1000 INR in 2 days
(0 Reviews)
0.0
sbpelek

I can prepare a sheet as flowchart to make you understand easily and can prepare the file you need

₹1300 INR in 2 days
(0 Reviews)
0.0