[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.



Skills: Excel, Visual Basic

See more: 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

About the Employer:
( 5 reviews ) Huntington, United States

Project ID: #22330432

Awarded to:


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 in 2 days
(116 Reviews)

9 freelancers are bidding on average $128 for this job


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 in 1 day
(163 Reviews)

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 and I do not More

$155 USD in 3 days
(46 Reviews)

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 More

$111 USD in 1 day
(18 Reviews)

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 More

$150 USD in 2 days
(3 Reviews)

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 More

$180 USD in 2 days
(24 Reviews)

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 More

$100 USD in 1 day
(9 Reviews)

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 More

$155 USD in 8 days
(0 Reviews)

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

$140 USD in 7 days
(0 Reviews)