Lukket

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.

Evner: Excel

Se mere: 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

Om arbejdsgiveren:
( 0 bedømmelser ) United Arab Emirates

Projekt ID: #15812444

58 freelancere byder i gennemsnit $101 på dette job

$115 USD in 0 dage
(249 bedømmelser)
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 Flere

$140 USD in 3 dage
(212 bedømmelser)
7.3
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 - Flere

$150 USD in 3 dage
(239 bedømmelser)
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 Flere

$40 USD in 3 dage
(242 bedømmelser)
6.4
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 Flere

$50 USD in 3 dage
(99 bedømmelser)
6.2
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 in 3 dage
(42 bedømmelser)
5.9
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 Flere

$40 USD på 1 dag
(49 bedømmelser)
5.6
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 Flere

$90 USD på 1 dag
(63 bedømmelser)
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 Flere

$30 USD på 1 dag
(48 bedømmelser)
5.3
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 Flere

$60 USD in 0 dage
(65 bedømmelser)
5.3
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 Flere

$200 USD in 3 dage
(11 bedømmelser)
4.8
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 Flere

$40 USD på 1 dag
(22 bedømmelser)
4.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 in 0 dage
(15 bedømmelser)
3.2
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 Flere

$111 USD in 3 dage
(3 bedømmelser)
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 Flere

$50 USD in 3 dage
(9 bedømmelser)
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.

$35 USD på 1 dag
(1 bedømmelse)
2.2
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 Flere

$144 USD in 2 dage
(1 bedømmelse)
1.8
DMerlacco

Hi Danielle, I am a professional accountant and have been developing excel reporting and modelling tools for businesses for over 8 years. Your project should take me all of five minutes. As I am new to freelancing I am Flere

$30 USD på 1 dag
(1 bedømmelse)
1.8
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 in 10 dage
(1 bedømmelse)
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 på 1 dag
(1 bedømmelse)
1.0