Tamamlanmış

need to write a macro that counts based on cell color and text value

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

Beceriler: Excel, Excel Macros

Daha fazlasını gör: excel count cells by color conditional formatting, excel formula based on font color, how to count colored cells in excel using countif, how do i sum colored cells in excel, count colored cells in excel mac, count colored cells in excel without vba, sumif font color is red, excel formula to count colored cells, visual basic macro copy paste cell, need javascript menu system based images, macro move data cell, macro move data cell database excel, remove color text, color text box, macro cut paste based cell value, excel macro cut paste based cell value, macro search website based cell content excel, macro copy rows excel based cell content, write macro user input text message box display powerpoint, need write text

İşveren Hakkında:
( 0 değerlendirme ) Washington, United States

Proje NO: #18981028

Seçilen:

cgullapalli

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

%selectedBids___i_period_sub_7% gün içinde 30%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(814 Değerlendirme)
7.9

Bu iş için 20 freelancer ortalamada $30 teklif veriyor

schoudhary1553

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. Daha Fazla

$100 USD in 2 gün içinde
(293 Değerlendirme)
7.7
ksriniravi

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(165 Değerlendirme)
6.6
shafaqat11

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(93 Değerlendirme)
6.1
SShtv

Hi, I'm interested in your proposal. Your task is clear to me and I am ready to solve it. I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA. These a Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(75 Değerlendirme)
5.9
sarcscoin

Hi, I have referred the Screen Shot. Hopefully, i can make use of the conditional formatting rules applied to highlight the colours and matching text in A2 instead of macros. If it is complex to do so, i will wri Daha Fazla

$20 USD in 0 gün içinde
(63 Değerlendirme)
5.6
rinabuoy13

Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards Rina B.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(75 Değerlendirme)
5.6
nvchien94

Hello there, I am an Excel VBA coder with 100+ macro created. I can give you a script to do this task for you. I see the picture and estimate the time to complete is 10mins. I can start right now if you want. Ple Daha Fazla

$15 USD in 0 gün içinde
(47 Değerlendirme)
4.5
Mokshith30

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 Daha Fazla

$20 USD in 0 gün içinde
(29 Değerlendirme)
4.0
ricardoba13

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

$88 USD in 3 gün içinde
(14 Değerlendirme)
4.0
gsanggara

Hi hartjas1, I am interested to your project. I know advance excel very well and able to write vba script to do count based on cell color and text value as mentioned in project desc.. Please ping me to discuss fur Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(21 Değerlendirme)
3.8
CronyTech

I can do what you need. I already have a macro that counts by color so it would be very quick to add the condition on the value of the cell. The macro currently works like this: you select a pattern cell and then a ran Daha Fazla

$30 USD in 3 gün içinde
(3 Değerlendirme)
2.9
ravim211071

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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
0.7
memosaid

I have worked with various admin support companies which develop my skills in awarding with excellent, effective and efficient results as per my jobs responsibility. I am in search of new and challenging responsibiliti Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
tramos00

Experienced with that kind of projects. Advanced problem solving and analytical skills. Detail oriented and committed to accuracy. Adaptable and reliable.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
uindusara

i have great ability about ms excel and vb so i can do your job in an hour please send your job details.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
antoniodotne

asp.net, macro programming. Software Engieneer. 1-5 days. For any questions, I remain at your disposal Antonio.

$25 USD in 10 gün içinde
(0 Değerlendirme)
0.0
EDSRD

Hi, We have been working excel macros since 8 years now. We have understood some part of the requirement. Just need to get few clarifications and we will be able to start the work immediately. Kindly share the file Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
nagarjunjntu

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
omkarvarvatkar

I am a new freelancer, and i want to proove myself, If you give me a chance I will definitely fullfill your requirments.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0