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:
>=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.
58 freelancere byder i gennemsnit $101 på dette job
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
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
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.
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