Færdiggjort

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

Thanks,

Brian

Evner: Excel, Visual Basic

Se mere: 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

Om arbejdsgiveren:
( 1 bedømmelse ) Huntington, United States

Projekt ID: #22330432

Tildelt til:

rashedkhanrubel

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 dage
(48 bedømmelser)
4.9

10 freelancere byder i gennemsnit $120 på dette job

mtdevil369

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 på 1 dag
(146 bedømmelser)
6.1
StormLion227

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 Flere

$155 USD in 3 dage
(39 bedømmelser)
5.4
Aishwaryakumari

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 Flere

$180 USD in 2 dage
(23 bedømmelser)
3.7
MonisZafar

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 Flere

$100 USD på 1 dag
(6 bedømmelser)
2.9
fastwork86

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 Flere

$150 USD in 2 dage
(1 bedømmelse)
1.0
MartinDudumi

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 Flere

$111 USD på 1 dag
(2 bedømmelser)
0.4
umairkaramat24

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 Flere

$155 USD in 8 dage
(0 bedømmelser)
0.0
WebTopMaster

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 Flere

$50 USD på 1 dag
(0 bedømmelser)
0.0
marcia1357

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 dage
(0 bedømmelser)
0.0