Fermé

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

Please email me: [Removed by [url removed, login to view] 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

Voir plus : vba conditional formatting formula, array formulas conditional formatting, conditional formatting array formulas, 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, excel 2003 conditional formatting, visual basic code conditional formatting, linux expert required, conditional formatting project dates, conditional formatting excel 2003 visual basic

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

N° du projet : #15812444

61 freelancers are bidding on average $102 for this job

115 $ USD en 0 jours
(249 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

140 $ USD en 3 jours
(197 Commentaires)
7.1
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

150 $ USD en 3 jours
(235 Commentaires)
6.9
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

40 $ USD en 3 jours
(217 Commentaires)
6.3
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

50 $ USD en 3 jours
(93 Commentaires)
6.1
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 en 3 jours
(25 Commentaires)
5.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 Exp Plus

90 $ USD en 1 jour
(45 Commentaires)
5.0
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

40 $ USD en 1 jour
(41 Commentaires)
5.1
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

60 $ USD en 0 jours
(61 Commentaires)
5.2
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

30 $ USD en 1 jour
(25 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

200 $ USD en 3 jours
(2 Commentaires)
3.6
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

40 $ USD en 1 jour
(15 Commentaires)
3.3
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 en 1 jour
(1 Commentaire)
2.2
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 en 10 jours
(1 Commentaire)
1.3
marieea786

A proposal has not yet been provided

35 $ USD en 1 jour
(2 Commentaires)
2.4
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 en 0 jours
(1 Commentaire)
0.8
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

50 $ USD en 3 jours
(2 Commentaires)
0.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 Exper Plus

111 $ USD en 3 jours
(1 Commentaire)
0.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

144 $ USD en 2 jours
(1 Commentaire)
0.5
abdulrafeytoodee

Hey, it’s me Abdul Rafey. I am data entry expert.I can provide you a reliable and on time Analysis support as per your requirement. My aim is to build trustable relationship with clients. Relevant Skills and Experienc Plus

155 $ USD en 3 jours
(0 Commentaires)
0.0