åbn

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.

Færdigheder: 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

61 freelancere byder i gennemsnit $103 for 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 Mere

$140 USD in 3 dage
(195 bedømmelser)
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 - Mere

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

$40 USD in 3 dage
(215 bedømmelser)
6.2
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 Mere

$50 USD in 3 dage
(93 bedømmelser)
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 in 3 dage
(23 bedømmelser)
5.4
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 Mere

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

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

$60 USD in 0 dage
(61 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 Mere

$30 USD på 1 dag
(24 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 Mere

$40 USD på 1 dag
(15 bedømmelser)
3.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 Mere

$200 USD in 3 dage
(1 bedømmelse)
2.9
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
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
marieea786

A proposal has not yet been provided

$35 USD på 1 dag
(2 bedømmelser)
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 in 0 dage
(1 bedømmelse)
0.8
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 Mere

$111 USD in 3 dage
(1 bedømmelse)
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 Mere

$144 USD in 2 dage
(1 bedømmelse)
0.5
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 US Mere

$30 USD på 1 dag
(0 bedømmelser)
0.0
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 Mere

$155 USD in 3 dage
(0 bedømmelser)
0.0