Fermé

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

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.

Compétences : Excel

en voir plus : vba conditional formatting formula, array formulas conditional formatting, conditional formatting array formulas, excel conditional formatting formula based on another cell, conditional formatting in excel 2016, excel conditional formatting formula multiple conditions, excel conditional formatting if statement, conditional formatting excel 2007, excel if cell color is red then, excel conditional formatting formula if cell contains text, excel conditional formatting based on another cell, data entry, excel, formulas conditional formatting excel, formatting array formulas excel, conditional formatting cell contains number, conditional formatting formulas ratings, textile designer expert required lahore, vb6 conditional formatting excel, revit expert required

Concernant l'employeur :
( 0 commentaires ) United Arab Emirates

Nº du projet : #15812444

56 freelance font une offre moyenne de $101 pour ce travail

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(250 Commentaires)
7.6
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(260 Commentaires)
7.5
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(109 Commentaires)
7.0
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 - Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(250 Commentaires)
7.0
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 Experienc Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(259 Commentaires)
6.5
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 - Mi Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(106 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(53 Commentaires)
5.7
SShtv

Your task is clear to me and I am ready to execute the project for 30 USD for 1 day. Relevant Skills and Experience I have a successful experience of doing such work. As an example, I bring screenshots of one of the p Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(59 Commentaires)
5.7
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 Exp Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(81 Commentaires)
5.5
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(68 Commentaires)
5.3
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 hel Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(32 Commentaires)
4.8
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 E Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(12 Commentaires)
4.9
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(42 Commentaires)
4.6
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 Experienc Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(1 Évaluation)
3.3
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 Exper Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(3 Commentaires)
2.5
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 a Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(9 Commentaires)
2.7
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)
2.4
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(1 Évaluation)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)
1.0
faheemali354

Formula Relevant Skills and Experience I am working since 7 years with excel Proposed Milestones $133 USD - 1 day no

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0