Excel expert required: Excel formula's (conditional formatting and IF formulas)

$30-250 USD

Imefungwa

Imechapishwa

over 6 years ago

$30-250 USD

Kulipwa wakati wa kufikishwa

Please email me: [Removed by Freelancer.com Admin] so i can send you the spreadsheet to look at. I need to colour code Column I, rows 5-8. The coulour's need to be based on the percentages in column K. So colours need to shown on column I, but based on collumn K. Conditions as follows: >=10% gold >=0% and =-5% and =-10% and =lowest spot and < -10% green >=50%/O5 and < lowest spot purple =10%,"G",IF(N6>=0%,"Y",IF(N6>=-5%,"LB",IF(N6>=-10%,"DB")))) so this may help explain what I require. Please note, where it says lowest spot this is the min range of K5:K8 I also need to do the same colour coding on the below section 11 to 14. I will need to know how this is done so I can do it again in the future please.

Excel

Kitambulisho cha mradi: 15812444

Kuhusu mradi

52 mapendekezo

Mradi wa mbali

Inatumika 6 yrs ago

Unatafuta kupata pesa?

Barua pepe

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa

Pata malipo kwa kazi yako

Eleza pendekezo lako

Ni bure kujiandikisha na kutoa zabuni kwa kazi

52 wafanyakazi huru wana zabuni kwa wastani $102 USD kwa kazi hii

@schoudhary1553

Hello Sir, I am the expert freelancer for Excel expert required: Excel formula's job . i have deliver more than 280 projects with 100% client satisfaction. Relevant Skills and Experience I have more than 5 years of experience in Excel Proposed Milestones $140 USD - Excel expert required: Excel formula's (conditional formatting and IF formulas)

$140 USD ndani ya siku 3

4.9

(524 hakiki)

8.4

@asin1987

Dear Employer I am an excel expert and I will do the job for you. I have sent you mail as well. Please give me a chance. Thanks!! Relevant Skills and Experience EXCEL VBA MACRO Proposed Milestones $155 USD - Project

$155 USD ndani ya siku 3

5.0

(282 hakiki)

8.3

@TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Roy Relevant Skills and Experience excel Proposed Milestones $60 USD - after completion

$40 USD ndani ya siku 3

5.0

(496 hakiki)

7.8

@khushh07

Hi, I understand the project requirements and willing to start as soon as possible. Looking forward to work with you. Thanks & Regards Khushi India Relevant Skills and Experience Excel Proposed Milestones $150 USD - milestone

$150 USD ndani ya siku 3

4.8

(332 hakiki)

7.3

@shaily1227

I am having expertise in excel specially in formula if you can share your sheet so I can see the work. Relevant Skills and Experience Excel Proposed Milestones $30 USD - Done for 25$ in excel formula

$30 USD ndani ya siku 0

5.0

(166 hakiki)

6.7

@rohitpithisaria

Hello I am an excel expert and would like to bid on the project posted by you. I understand your requirement and will do the needful. Rgds Rohit Relevant Skills and Experience Excel Proposed Milestones $50 USD - Milestone Please share your excel file.

$50 USD ndani ya siku 3

4.9

(114 hakiki)

6.5

@younus15

Hello. I can do your project in less than an hour according to your description with full delivery and without error. I would also complete your project with the highest precision and quality. Relevant Skills and Experience I have extensive experience in Excel, Coding and Data processing. Proposed Milestones $90 USD - A

$90 USD ndani ya siku 1

4.9

(168 hakiki)

6.5

@The24CarrotsInc

Greetings for the day!! We have experience working on this subject. We ensure 100% QUALITY with ON-TIME Deliveries. Please allow us to take this opportunity. Thanks & Regards, Team@The24CarrotsInc VBA/EXCEL 100% Satisfaction Of Deliverable

$40 USD ndani ya siku 1

4.9

(56 hakiki)

5.8

@renesontiongson

Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much. Relevant Skills and Experience Excel automation Proposed Milestones $60 USD - 100% milestone and release upon completion

$60 USD ndani ya siku 0

4.9

(73 hakiki)

5.7

@AkilaArun

Hi, I would like to discuss on this task. I have done conditional formatting tasks in the past and can get this done. Relevant Skills and Experience I have over 5 years of experience working with Excel which would help in getting this task done. Proposed Milestones $40 USD - Final Job Completion.

$40 USD ndani ya siku 1

5.0

(52 hakiki)

5.7

@WesleyJeftha

I am a fluent English speaking Excel specialist. I work quickly, accurately and professionally. Relevant Skills and Experience 17 years Excel experience, 12 years corporate experience. Also used to teach and lecture Excel at University. Proposed Milestones $200 USD - Payment on completion, and after the client is totally satisfied with the end deliverable Additional Services Offered $30 USD - Excel training (per hour cost)

$200 USD ndani ya siku 3

5.0

(12 hakiki)

4.9

@aminayousaf2

Hi, I am professional in Data Entry. I know the importance of Data Entry Accuracy and on time delivery, I can do your task 100% accurate and will make sure to deliver on time. Hire me now Relevant Skills and Experience I have 1 and half year experience in Data Entry as professional Data Entry Operator in an organization. Expert in Excel, Word, Power Point, and PDF writing. Proposed Milestones $144 USD - Complete job

$144 USD ndani ya siku 2

5.0

(1 hakiki)

3.3

@MuneebAhmad906

I am a medical student who has been freelancing for three years. I can provide you samples of my work. I hope you give me a chance. Relevant Skills and Experience I have been doing data entry for quite some time now and I know the ins and outs of the job. I think I can be the perfect person for your job. Proposed Milestones $50 USD - When you are satisfied

$50 USD ndani ya siku 3

4.5

(9 hakiki)

3.0

@SJavagar

I have 10 years of experience in MS Excel. I can get your projected completed within 2 hours. Relevant Skills and Experience Ms Excel Stay tuned, I'm still working on this proposal.

$35 USD ndani ya siku 1

5.0

(2 hakiki)

2.4

@jawadrafia

Dear Sir, I am a professional person having 10 years’ experience in Microsoft Excel and you can review my profile. By viewing your project, I am offering my services for the project, Regards, Relevant Skills and Experience I am an expert in: 1. Formulas, Graphics, Charts, Pivot Tables and Power Pivot 2. Data analysis tools, Queries and Solver 3. Professional formatting in Excel 4. Any task in excel Proposed Milestones $111 USD - I can do any task in excel as you required and i need 5 star rating after your satisfaction. I can do any task in excel as you required and i need 5 star rating after your satisfaction.

$111 USD ndani ya siku 3

4.9

(3 hakiki)

2.5

@arbods

I'm an expert in Excel and in Excel macros via VBA. So if you interested on valuable result I would glad to start just now. Best regards

$277 USD ndani ya siku 10

5.0

(1 hakiki)

1.3

@viswakarmaya

would be able to resolve the issues on the same day. Relevant Skills and Experience Excel Expert, Excel VBA expert Proposed Milestones $35 USD - completion of the project kindly send the excel file for formating

$35 USD ndani ya siku 1

5.0

(3 hakiki)

1.3

@sam68

Hi There, I am useful for this job. You can hire me for this project. I did it before once. You can faith on me for this project. check my email Relevant Skills and Experience Excel Formula Proposed Milestones $30 USD - Submitting final draft Will you give me this project for work?

$30 USD ndani ya siku 1

5.0

(2 hakiki)

1.1

@Arfahameed

Hey, it’s me Arfa. I am talented and professional research and academic writer. Relevant Skills and Experience I have worked on many projects like business plan, research, thesis and portfolio assignments. Thanks Proposed Milestones $155 USD - 155

$155 USD ndani ya siku 2

0.0

(0 hakiki)

0.0

@malcaide1827

With advanced skills in excel functions, conditional formatting and formulas. Used in doing templates and excel macros to minimize manual work Relevant Skills and Experience Advanced excel familiarity with VBA programming skills. Working in the banking/financial industry and with high exposure in using excel. Proposed Milestones $155 USD - 155 Additional Services Offered $10 USD - Automated generation of reports if we need to reproduce this into a new file.

$100 USD ndani ya siku 2