Assistance with Microsoft Excel for MAC 2011
- or -
Post a project like this2324
$$$
- Posted:
- Proposals: 5
- Remote
- #1809302
- Completed
Description
Experience Level: Expert
Description of excel work: hi there,
I require the help of an expert on Excel for MAC 2011, specifically Conditional Formatting.
Hopefully i explain this correctly:
I am wanting to compare the prices of products between my competitors and myself.
I have 145 rows of products with 9 columns (C-K) showing size of each products eg:
Column C 1kg Column D 500g Column E 250g
A Prod 1 $100 $50 $25
B Prod 2 $80 $40 $20
I have the pricing of 13 competitors, set up in exactly the same way ie Competitor 1 columns L-T, Competitor 2 columns U-AC and so on………
I have already entered conditional formatting into columns L-T compared with my company columns C-K (see attached screenshots).
I have struggled and struggled to find anywhere on the net that will assist me in easily copying and pasting the formatting from one column to another and it auto changes the column numbers eg if i copy the above format into column K why cant it auto change L to K and C to D?).
Therefore i am looking for an expert who can either a) know the trick or b) do it manually for me.
Please only enquire for the job if you know exactly how to do this. I have no time or patience for applicants who dont know the answer. I have respect for all applicants, but seriously this is a job that needs to be done quickly, yet with absolute perfection. Please do not blag your way into the job. You are either an expert on this specific issue or not - it will only earn you a bad review.
Look forward to your help - my persistance has been driving me mad all day!
Thank you
Extra notes:
I require the help of an expert on Excel for MAC 2011, specifically Conditional Formatting.
Hopefully i explain this correctly:
I am wanting to compare the prices of products between my competitors and myself.
I have 145 rows of products with 9 columns (C-K) showing size of each products eg:
Column C 1kg Column D 500g Column E 250g
A Prod 1 $100 $50 $25
B Prod 2 $80 $40 $20
I have the pricing of 13 competitors, set up in exactly the same way ie Competitor 1 columns L-T, Competitor 2 columns U-AC and so on………
I have already entered conditional formatting into columns L-T compared with my company columns C-K (see attached screenshots).
I have struggled and struggled to find anywhere on the net that will assist me in easily copying and pasting the formatting from one column to another and it auto changes the column numbers eg if i copy the above format into column K why cant it auto change L to K and C to D?).
Therefore i am looking for an expert who can either a) know the trick or b) do it manually for me.
Please only enquire for the job if you know exactly how to do this. I have no time or patience for applicants who dont know the answer. I have respect for all applicants, but seriously this is a job that needs to be done quickly, yet with absolute perfection. Please do not blag your way into the job. You are either an expert on this specific issue or not - it will only earn you a bad review.
Look forward to your help - my persistance has been driving me mad all day!
Thank you
Extra notes:
Justin F.
100% (11)Projects Completed
12
Freelancers worked with
9
Projects awarded
55%
Last project
14 Feb 2018
Thailand
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