Đã hoàn thành

[EXPERT EXCEL VBA ONLY] Color Code Dependent Cells by Level

I would like to have an efficient excel macro that shows three different categorizations of cells on a sheet. These three levels are detailed below: (1) Any non-blank cell that does not have any dependents (text or hardcodes included); (2) Cells that ONLY have dependents on the active sheet; and (3) Cells that ONLY have dependents on the non-active sheet in the same workbook.

Other Key Points:

1. We want to save the existing format of the sheet (the "Before_First_Click" tab, for example) so we are able to return back to this format.

2. The code should be one macro that toggles between the two different formats ("Before_First_Click") and ("After_First_Click") tabs show the two sample formats.

3. To be clear, this code needs to be flexible for any amount of cells on a given sheet, complex formulas such as sumifs or vlookups / index-matches

4. We want to ignore blank cells

5. Color cells with TEXT and color cells with VALUES (hardcodes) with a white background (255/255/255)

6. VERY IMPORTANT: we need to have a priority list for cells that satisfy both Level 3.0 and Level 2.0. If a cell meets Level 3.0 AND Level 2.0 criteria, we should color it with the Level 3.0 color.



Kĩ năng: Excel, Visual Basic

Xem nhiều hơn: excel vba menu code, excel vba code optmization, excel vba paste csv cells, highlight cells with formulas in excel 2010, highlight cells referenced in excel formulas, excel f2 not highlighting cells, excel formula color cell if value, used to find which cells are referenced in a formula, excel formula not highlighting cells, excel change cell color based on value of another cell, excel highlight formula cells shortcut, excel vba code optimis, excel vba programing expert, code excel vba color alternating rows, excel vba code log websites, excel vba expert resume, update code project excel vba, become expert excel vba, code cut pasting cells excel vba, excel vba serial port code

Về Bên Thuê:
( 1 Nhận xét ) Huntington, United States

ID dự án: #22330432

Được trao cho:


Hi, I have understand the project requirement & interested to make macro for this project. Please send a message so we can discuss more & start the project. Thanks.

$80 USD trong 2 ngày
(48 Đánh Giá)

10 freelancer đang chào giá trung bình $120 cho công việc này


Hi, I have understand the project requirement & interested to work for this project. I will complete it by 15 hours. Please send a message so we can discuss more & start the project. Thanks.

$80 USD trong 1 ngày
(146 Nhận xét)

Hello. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. An Expert Excel/VBA programmer on freelancer.com and I do not Thêm

$155 USD trong 3 ngày
(39 Nhận xét)

Dear Client, I'm Expert in VBA. I have excellent experience of Excel (VBA/MACROS/FORMULA'S),Data entry, Web Scrapping (Python and Selenium) and Web Research for more than 4 Year’s. Never ends up until you are 100% sa Thêm

$180 USD trong 2 ngày
(23 Nhận xét)

Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this easily with a VBA Macro. I've completed many projects on this platform using VBA. Your work will be completed quick Thêm

$100 USD trong 1 ngày
(6 Nhận xét)

Hi Brian, I am Sumit Choudhary. I saw your requirement for an excel vba project on color code dependent cells I have an MBA and have extensive experience in tutoring students in Economics, Operations Research, Projec Thêm

$150 USD trong 2 ngày
(1 Nhận xét)

The only thing that i can say to convince you is you have to try my abilities. I think i have the proper skills plus 10 years of experience working on big data with the proper analytical skills. Problem Solving with c Thêm

$111 USD trong 1 ngày
(2 Nhận xét)

Hello There. How are you doing?. I have read the description, I have great experience doing similar jobs related to these skills Excel, Visual Basic. Please start the chat so we can have detailed discussion. Thanks. Hi Thêm

$155 USD trong 8 ngày
(0 Nhận xét)

Hello. How are you? I have just read your requirement carefully and I know what you are looking for. I have done similar work in the past, so it won't take much of your time. Do not pay me until you get full satisfact Thêm

$50 USD trong 1 ngày
(0 Nhận xét)

gostaria realizar este projeto pois posso realizar o mesmo com foco e dedicação e tenho experiencia com atendimento ao publico.

$140 USD trong 7 ngày
(0 Nhận xét)