Replicate an excel document with advanced conditional formatting & macro
3438
£20(approx. $25)
- Posted:
- Proposals: 13
- Remote
- #600685
- Archived
66498498984251965348179443720486495505562545790660034665266698473759980
Description
Experience Level: Entry
Estimated project duration: less than 1 week
General information for the business: Excel document with advanced conditional formatting & macro
Industry: Internet/Software
Description of excel work: Im looking for somone to replicate the attached document but with advanced conditional formatting & macros.
I have applied conditional formatting to the document but on each individual cell which is time consuming. Im not sure how to do this in a more advanced way.
You have Client A, Client C and Client T down the left hand side.
You have ENGINEERING - PROCUREMENT & CONSTRUCTION along the top with A, C & T which is client A, Client C and Client T. Each cell there has a dropdown with the value Yes/No.
When a user selects Yes from ENGINEERING A, it will highlight all the systems in Client A.
When user selects Yes from ENGINEERING C, Client C systems highlight ( i want text to appear here. I havent added it as not sure how to do it.
So just replicate the excel document as it is with conditional formating. Very simple and quick.
The only other additional formatting is within Client A Systems for Engineering, Procurement and Construction . If you select cell B9 with an x, it highlights and also highlights the system below (ctr management). The same if you select the Trackers cell B11 with an x, it shows the other systems that need to be used...pamms and JMS. i need a few more added which we can can discuss when job awarded.
So basically I need you to replicate what ive done exctly as it is but with some additional work to few other cells. Thats the first stage, aftr that i need additonal work which i can create a new proposal for or just add payment.
I understand excel enough to create this document which took me no time at all so i know someone could do this in less than an hour.
This document is going to continue to develop further and get more complicated highlighting cells on different sheets etc so there is more work after this.
Please document how you have done this so i can edit document further down the line
Ive just put a price down but make me offer higher or lower depending on how ling you think will take you. There is output data required in the next stage of the work which will be higher payment.
Extra notes:
Industry: Internet/Software
Description of excel work: Im looking for somone to replicate the attached document but with advanced conditional formatting & macros.
I have applied conditional formatting to the document but on each individual cell which is time consuming. Im not sure how to do this in a more advanced way.
You have Client A, Client C and Client T down the left hand side.
You have ENGINEERING - PROCUREMENT & CONSTRUCTION along the top with A, C & T which is client A, Client C and Client T. Each cell there has a dropdown with the value Yes/No.
When a user selects Yes from ENGINEERING A, it will highlight all the systems in Client A.
When user selects Yes from ENGINEERING C, Client C systems highlight ( i want text to appear here. I havent added it as not sure how to do it.
So just replicate the excel document as it is with conditional formating. Very simple and quick.
The only other additional formatting is within Client A Systems for Engineering, Procurement and Construction . If you select cell B9 with an x, it highlights and also highlights the system below (ctr management). The same if you select the Trackers cell B11 with an x, it shows the other systems that need to be used...pamms and JMS. i need a few more added which we can can discuss when job awarded.
So basically I need you to replicate what ive done exctly as it is but with some additional work to few other cells. Thats the first stage, aftr that i need additonal work which i can create a new proposal for or just add payment.
I understand excel enough to create this document which took me no time at all so i know someone could do this in less than an hour.
This document is going to continue to develop further and get more complicated highlighting cells on different sheets etc so there is more work after this.
Please document how you have done this so i can edit document further down the line
Ive just put a price down but make me offer higher or lower depending on how ling you think will take you. There is output data required in the next stage of the work which will be higher payment.
Extra notes:
David F.
87% (3)Projects Completed
3
Freelancers worked with
3
Projects awarded
23%
Last project
8 Apr 2016
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies