Support Ring Macro
$10-30 USD
Paid on delivery
I have a lookup table that returns text; either, Red, Blue, Black, Green, Purple, Maroon, or Grey depending on the lookup criteria. They show up in black font color in the destination cell. I need a macro that will run automatically and change the font color to be the same as the text reads. For example, if the lookup table reports Red, into cell C6, then change the font color to red. If the table reports purple, then change the font color to purple, etc. Further I want several other cells (say D23, H12, and K23) to be shaded the same color as the changed text color.
So, if the lookup table reports green to cell C6, the macro would change the word green to a green color, and shade cell D23, H12, K23 to the same green color.
I need the macro and the VBA code to execute same.
Project ID: #35079701
About the project
Awarded to:
19 freelancers are bidding on average $24 for this job
Greetings! This is a pretty straightforward requirement. Please share the current file. To make it a flexible solution, I can add couple of columns - one column to specify the exact color code, another column to spe More
Hello, I am an Excel expert. I offer my services to develop macro that will run automatically and change the font color to be the same as the text reads and several other cells (say D23, H12, and K23) to be shaded the More
Hi, I can develop Excel VBA Macro as per your requirements. I am experienced Data Analyst and Macro Developer and have done many similar projects. So, can do this job nicely. Ready to start please message me to di More
Hi there, I'm an Advanced Level Excel Expert and will do it. Please send me a message so we can discuss further. Thank You
Hello, sir! I have read your requirement and I noticed that I am appropriate to this project. I have rich experience with data processing using Excel formula and VBA. All clients call me "Princess of Excel". I promise More
Hi sir/ madam I am senior data analyst with advance excel and vba with automation for routine work. also, I can handle SQL, UiPath, please let me know I can help you further My top skills are: Excel with advanced f More
Mabith C. Tolo P-2 Bonbon, Butuan City 09484222741 Hi, I am very interested in the said job post; I have work as encoder/office staff for different clients. SKILLS INCLUDE BUT ARE NOT LIMITED TO: *CUSTOMER SERVICE *BA More
Have faith in yourself, whatever you do, do it with full strength and hard work. Do not be like everyone else.
can be of good use if you put me in the this position. Being a multitasking expert I believe a this would be the best job for me. I am skillful in tiktok and have possessed many soft skills as well.
Hi, I have experience with excel and would love to work on the project. The criteria you described can be implemented using VBA and formulae in the sheet itself as well.
Hi, I'm a Reliable and Professional freelancer with 4 years experience of in Data Entry, Data Mining, Copy Paste, and Internet research. Accuracy is my first priority. I always meet deadlines and provide quality works. More