need to write a macro that counts based on cell color and text value
$10-30 USD
Paid on delivery
I need to write a macro that counts the number of cells that have a text value in column B that matches A AND matches has a certain color. Picture attached. So for example cell B2 counts if the value of B16-B200 if they have the same name (value is the same as A2). I need to create a macro for C2-F2 that will count the number of cells that have the same name AND will count how many of those are yellow (for C2), Green (for D2), Red (e2), and blue (f2).
Project ID: #18981028
About the project
Awarded to:
HI, I am good at Excel and VBA. I have referred the attachment provided. You want to get the count based on the colours and matches. Looking forward to discuss in the chat and start working on it. -Chandra
20 freelancers are bidding on average $30 for this job
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. More
Greetings! I can write a macro to count based on cell value and cell color combination. Being a full time freelancer working exclusively on Excel based projects, I work on developing macros every single day. I ha More
Hi, I can confirm you that I will be able to complete your project with the highest quality and accuracy. No need to pay me anything if you are not satisfied with my work. I will be more than happy if I get the oppo More
Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards Rina B.
Hi I have Read Your Requirements I am Excel VBA Expert Experianced in VBA Macros & Web Scraping Script... I can finish any kind of vba task in 1 day only pls see my previous projects for my vba experiance T More
What about having the option of using a custom formula like =HOWMANY(Yellow, C2:B2) My name is Ricardo and I can do that for you
asp.net, macro programming. Software Engieneer. 1-5 days. For any questions, I remain at your disposal Antonio.
Experienced with that kind of projects. Advanced problem solving and analytical skills. Detail oriented and committed to accuracy. Adaptable and reliable.
hi there I am expert in excel macro and advanced formulas. I am sure that i know how to solve your problem and give you best result in alloted time.
i have great ability about ms excel and vb so i can do your job in an hour please send your job details.
Hi, Having good expertise in Excel macros. I am able to prepare code to identify the data by color of the cell and then provides the count. Please let me know if I can assist you in this work. Looking forwa More
I am a new freelancer, and i want to proove myself, If you give me a chance I will definitely fullfill your requirments.