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