Replicate an excel document with advanced conditional formatting & macro

  • Posted:
  • Proposals: 13
  • Remote
  • #600685
  • Archived
Kumail R.Kunj S.Ngoni S.Rony J.Ilyas A. + 8 others have already sent a proposal.
  • 5

Description

Experience Level: Entry
Estimated Job 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:

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.