need to count numbwer of cells based on the conditinal formatting and next coloumn data

Job ID: 35853051

Budget: ₹600 – ₹1,500 INR

based on the share type filter I need the total count of green, red, and yellow for each share type which is in the excel for each day
Related categories: Data Processing Excel Excel VBA Excel Macros