Conditional Formatting
₹600-1500 INR
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.
Project ID: #10628596
About the project
Awarded to:
Hi, I can do this and will inform you with the procedure as well. Waiting for your reply. Thanks....
26 freelancers are bidding on average ₹1092 for this job
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
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
Expert in excel... Can start right away with this and deliver good quality work within deadlines. Look forward to work with you
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
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
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
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
Hii, i am very well in terms of excel work, i know many formulas which can your work easy in less time....
We are a group of chartered accountants , running a small BPO, doing all types of Data processing services
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.
I can prepare a sheet as flowchart to make you understand easily and can prepare the file you need